Multiple Value Lists

[Database Designs]

Is it possible to have multiple value lists for the same filed based on another fields data?

For instance if Field A = Yes than I want the drop-down in Field B to be ValueList#1. If Field A = No than I want drop-down ValueList#2.

[aldipalo]

It is called a 'Conditional Value List.' You'll find plenty of discussion about it. Do a search for Conditional+Value+List.

Here's an example as well. I found this somewhere on the Forum and do not remember who posted it, but, it a good example.

If you have any further questions let us know.

hth

Conditioanl_Value_List.zip

[Database Designs]

I'm not real good with conditional lists. I have attached a sample file with2 tables. First is a Cemetery Records table that will contain all lots that are occupied. The other table is All Burial Spaces that includes every possible lot in the cemetery. If I want to add new records then I have no problem with my drop-down lists. But if I go into Find Mode I can't get them all to work. Can you tell me how I can do this?

Test.zip

[aldipalo]

See attached. Does this give you what you are looking for? When you have a wide CVL I start losing focus as well, but, I think I've set it up for what you need. Let me know.

CVLTest_Mod.zip

[Database Designs]

Thank you. That's what I was looking for but I think I was getting way too confused. Thanks again.

[comment]

What exactly is the difference? AFAICT, the original file works fine in Find mode - provided there *is* related data to show.

However, there is another issue here: I see that at least the Row numbers are not necessarily unique. There is a Row 1 of Block 13, and a Row 1 of Block 14, and so on. Basing a relationship solely on Row means that the next selection will show Lots from ALL blocks with the selected number - regardless of what was selected as Block, Section and Style. You need to ADD a matchfield to each relationship down the line, where the data may not be unique - or make sure that row numbers are unique within the entire table.

All of this would become apparent, if you had some decent data to test with.