Scripting If..Else Pop-up lists

[Shaunaq]

Hi,

I was wondering if it is possible to do a If..Else structure in such a way that when I select a certain field from a pop-up list, the pop-up list used by a second field is different. Made no sense? Well, to explain it a little bit further, suppose I have two text fields called Country & Culture (Both use pop-up lists). For every country, there is a separate list of cultures. Can I define various different value lists for these cultures, & make it so that the field knows which value list to use depending on the country chosen? Or is there another way to acomplish the same without using pop-up lists etc.

This is a database that is fianlly going to be printed out for a museum, so both country and culture should show in the print out & the screen.

Thanx a lot!

Shaunaq

[goostree]

Look up heirarchical value lists on John Mark Osborne's www.databasepros.com. It will allow your value lists to change based on the value of a field.

These are also called conditional value lists. I think there has been a thread on this recently somewhere in this forum. Check the value lists forum.

[andygaunt]

Hi,

AS goosetree said, conditional value lists.

The easiest way to get this information is if you have a second database.

This database has two fields, country and culture.

Create a record for each country and the relevant culture. You will end up with many records for country, each with a specific culture.

Now, in your main database, create a relationship, from country to country in the new database.

Now, your culture value list. Specify use values from a field, then choose the show only related values. Select your country::country relationship and choose culture as the field to get the values from.

Now, when you choose a country, only those cultures that match will display in the second value list.

HTH

[gnarlydude]

Thank you so much Andy! I have posted similar questions trying to figure out how to do this and many people offered help. Your post was the first one, however, that made sense to my admittedly feeble mind. I just followed your advice step by step and viola! CONDITIONAL VALUE LIST! YEAH! One question though. Is it possible to set the order in which the values are listed in the conditional value list? In the above example that would be the cultures. It seems as though they are listed alphabetically and I would prefer that they be listed in the order in which I entered them.

Thanks,

Joe