Jump to content

2 Value Lists


FaeryHigh

This topic is 6102 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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
Link to comment
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
Link to comment
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"

Link to comment
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?

Link to comment
Share on other sites

This topic is 6102 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.