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 May 9, 200916 yr by Guest

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.

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