Jump to content
Sign in to follow this  
Greg M

Value list consisting of repetitions of a single field on the current record

Recommended Posts

I have a database in FMP9A which stores records for individuals and a related table which stores incidents. In the table for individuals, I have a GUID field which holds 20 repetitions to store the unique identifiers assigned to each individual.

A portal is used to create related records in the incident table. Incidents are logged by GUID. Since one individual can be associated with multiple GUIDs, I currently have a value list created from the GUID field, but this list contains all the GUIDs for each individual in the database and gets cumbersome to navigate. I don't need to see all the other GUIDs that aren't associated with the individual when logging an incident. Is there a way to create a value list that contains only values from the repeating field on the current record?

Edited by Guest

Share this post


Link to post
Share on other sites

I am not sure what is a GUID or why an individual needs 20 unique identifiers, but I believe you could get the value list by defining a self-join of the individuals table, matching an individual to itself only. Then set the value list to include only related values.

Share this post


Link to post
Share on other sites

Yes, that did it. Thanks. Still making the jump from 6 to 9 :

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.