Jump to content

Contextual Menu's


principal
 Share

This topic is 5668 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

This topic is 5668 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.