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

[Greg M]

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

[comment]

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.

[Greg M]

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