Multiple conditional value lists

[ministrymaker]

I'm trying to create multiple conditional lists on the same layout so that multiple options can be selected in a conditional relationship. I want the same options for each list without duplicating what is in the field above it.

Let me try to illustrate:

Since countries seems to be popular, I'll use countries. I want one value list to display the continent, and the other to display the countries of that continent, ie.

Europe > France

Africa > Kenya

Europe > Spain

Asia > China

Etc.

A simple conditional values list (which I have figured out.)

The trouble I'm having is that I want more than one field showing the same value lists. For example, I want several "Continent" fields with their corresponding "Country" fields.

Can this be done?

I've included a picture of what I'm trying to explain.

Thanks

[Fenton]

I think the simple answer, if you've managed to do it once, is to do it 3 times. Each one has nothing to do with the other one; so it's 3 different value lists, 3 different relationships.

[unless of course if it was relational structure, with the multiple choices in their own little table. Then it would be just one value list; but you probably wouldn't be asking the question.]

Edited August 16, 2007 by Guest

[ministrymaker]

Thanks Fenton

I was able to do as you said. I created separate value lists (which all had the same data) and then linked those as separate conditional lists. I've included my sample file for anyone to double-check.

It would be nice to only have one value list, that way I wouldn't have to create so many of the same value lists! But maybe that can't be done. The trouble I had was that the second and third related fields used the value from the first field to base it's conditional relationship off of. So even though I would choose "Europe" for the first field and "Asia" for the second field, the values for the second "Country" field would be based off of Europe in the first field! Is there any way around this?

Thanks for your help.

Countries.fp7.zip

[comment]

As Fenton said, you should go for a relational structure.

Countries.fp7.zip

[ministrymaker]

Comment,

That is exactly what I wanted!!!!

Thank you so much!