Jump to content
Sign in to follow this  
Database Designs

Multiple Value Lists

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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