filtered drop down

SELECTED ANSWER

replied on April 25, 2017

Yes Sweety you can.

You need two lookup rules. The first Lookup will populate the Countries into the County Field (either a Drop Down or Single Line field if you prefer Type ahead to Drop Drop.

In The Lookup area, create a Lookup with No When line, just populate the Country Data into the field using the Fill Command: Fill Country field from Country line of DB.

For the Next lookup, create a regular lookup for the States, When Country = Country, Fill States with States. The States Field would be a Drop Down

1 0

View 2 previous replies

replied on April 25, 2017

Thanks Steve, I never noticed I could delete the "When" part of a lookup.

0 0

replied on April 25, 2017

You are welcome Eric, in case you haven't tried this with the latest versions of Forms, if you use the Fill Command to populate a single line field with a lookup from a DB, such as Customer Name, that Field becomes a Type Ahead Style Lookup field. Meaning that as you Type the name into the field it will compare it against the data from the lookup and provide you a drop down of matches. The field is still Free Key meaning if nothing Matches you can just enter the value you want. I find this very useful when looking up Client Names for example and there would be too many Steve's to have them in a traditional Drop down field.

2 0

replied on April 25, 2017

I didn't know that either. Thank you.

0 0

replied on April 25, 2017

Then the table to which I am connecting should be like below?

0 0

replied on April 26, 2017

Yes, that is correct.

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.