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

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, 200718 yr by Guest

Sorry no attachment

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, 200718 yr by Guest
explanation

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"

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?

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?

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

Thanks for all your help!! Problem solved