Is there a way to create contextual drop down lists

Thanks in advance

I guess that you have for example two value lists in a row and when you select first, the second should give you an options based on first selection?

If so, you need two tables: Data and Value (for value list options).

Create two fields in data table and two in Value table:

- Data_Category1 and Data_Category2 (Data table)

- Value_Category1 and Value_Category2 (Value table)

Now fill Value table with sample data for value list like:

Value_Category1 | Value_Category2

Animals | Cat

Animals | Dog

Fruit | Banana

Fruit | Apple

...and so on...

Then go into define database and create relationships between data and table occurences (TO) of value table:

1st relationship (create extra TO named Value Category1):

Data_Category1 = Value_Category1

2nd relationship (create extra TO named Value Category2):

Data_Category1 = Value_Category1

AND

Data_Category2 = Value_Category2

Ok now you just have to create value lists:

First is easy, add new and name it like Category1 and select option use values from field and in option box select TO Value Category1, field Value_Category1 and on the bottom select include all values.

For second, add new name it like Category2 and select option use values from field and in option box select select TO Value Category1, field Value_Category2 and on the bottom select include only related values and as starting from select Data table.

Finally go to Data layout and change two fields (Data_...) from edit box to value list and for first select Category1 and second Category2.

HTH,

Dejan

Edited May 31, 200619 yr by Guest

DukeS - thanks my friend, I'll give that a whirl (looks like a lot of work) :

Your technique works great. I made a sample file for review using it. I even extended it to 3 levels of data. eg. fruit banana ripe

value.fp7.zip