The trick is to use individual records with non-repeating fields in place of the repeating fields. You can't match a single repetition to single records in a related table. Using a repeating field as a match field produces the same result as using a list of return separated values. The records match to any one of the repetitions.
Thanks Phil for your quick response. I am not using these fields in the relationship. This is done with serial numbers. And each table (X, Y) contains many more fields than the one described. Put differently: Is there a way to list all records values of a specific repetition in a calculation done in a related table.
Pull the data into a separate field such as this calcluation field:
GetRepetition ( RepeatingField ; 2 )
or just use the newer syntax:
RepeatingField [ 2 ]
Then you can use List to get a list of this non-repeating field that has extracted the data from the needed repetition.
PS. Repeating fields were basically an obsolete design option once FileMaker changed from "flat file" to "relational" with the release of FileMaker 3.0. While there still are a few specialized uses for repeating fields, they are few and far between--getting fewer with each new release of FileMaker.
I cannot get it working. The calculation field RepeatingField [ 2 ] in table Y does not return any values.
Nevermind, I am switching back to non-repeating fields. I tried repeating ones just to clean up some tables.