Jump to content
Sign in to follow this  
FaeryHigh

2 Value Lists

Recommended Posts

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

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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 by Guest
explanation

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

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.