2 Value Lists

[FaeryHigh]

Is if possible to have 2 value lists available to one field?

If Field 1 = Cats

Then field 2 = Cat Value List

If Field 1 = Dogs

Then field 2 = Dog Value List

[Brett W]

Hi here, not really two value list but the values related to both types. Set up a single value list that relates to the other table through a relationship set up to the type of animal. an easy set up is to use either dog or cat as a primary and foreign key. then, depending on the type, the related names will appear on the valuelist. check out the attached file.

test.fp7.zip

Edited July 12, 2007 by Guest

[FaeryHigh]

Sorry no attachment

[Brett W]

sorry about that, just edited the message and added the file. im not sure if this is the answer you were looking for. this method is relying on using a table as records (items) for the value list.

Edited July 12, 2007 by Guest
explanation

[FaeryHigh]

Alright, everything appears to be set up correctly. However the selection is listing the appropriate names, but when I click on them I'm still getting the animal. Is there some small detail I have over looked?

i.e.

selecting "poodle" shows up as "dog"

[Brett W]

make sure that the field you have set to use the value list is a local field to that table, no a referenced field from the value list table. sounds like you are referencing the key field on your layout.

did the example help?

[FaeryHigh]

The example was very helpful, but as the file was non modifiable I couldn't go in and pick it apart. I'm still trying to work through it. Could you clarify a little more on local?

[Brett W]

sorry again, i have adjusted the read/write on the file. What I mean by local is the field that you want to store the value in is local to the table and not the value list table.

test.fp7.zip

[FaeryHigh]

Thanks for all your help!! Problem solved