Conditional value list

[tau zi]

If anyone could help explain or show me an example of how to build a conditional value list where i can click an item from one value list drop down box which then displays information in another field it would be really appreciated.

Example:

I have option of choosing Lunch1, Lunch2, Lunch3, Lunch 4 from a drop box list. After clicking Lunch1, in a field next to it i want it to say HAMBURGER. if i click Lunch2 - Chicken. if i click Lunch3 - Salad etc.

Please help

Edited July 27, 2010 by Guest

[cpe1704tks]

tau zi,

I have created 2 tables with relationships and then values lists. Take a look and see if this is what you need.

If you want to use calculation there is the case function, but it is much more work.

Let me know, and i will make a simple calculation for you.

cpe1704tks

[tau zi]

Where can i access these tables?

[cpe1704tks]

tau zi,

The tables are there like any other table in the select layout drop down or select view, go to layout, select which one you want to see. Is this what you are asking?

cpe1704tks

[Lee Smith]

Your first reply sounded like you meant to attach an example file.

[Lee Smith]

I have option of choosing Lunch1, Lunch2, Lunch3, Lunch 4 from a drop box list. After clicking Lunch1, in a field next to it i want it to say HAMBURGER. if i click Lunch2 - Chicken. if i click Lunch3 - Salad etc.

Please help

Why the separate fields for lunch? You could just have a field for Lunch and use a list for the different selections.

Lee

[cpe1704tks]

Sorry your right i did not attach it. Here it is. I apologize tau zi.

lunch.zip

[comment]

After clicking Lunch1, in a field next to it i want it to say HAMBURGER. if i click Lunch2 - Chicken. if i click Lunch3 - Salad etc.

What you describe here is not a conditional value list, and could be done very simply:

lunch.zip

[tau zi]

Wow thank you so much that was soo much easier than the conditional value list i created thanks for your help!