Accessing second, third or fourth repetition of a field
I am new to Filemaker Pro Advanced v10 (or indeed all versions of FMP). Is there any way to access 2nd . . . 5th repetitions of a field to use the values in a calculation? Similar to accessing an array? For example, in a merge field only the first instance is displayed. If a movie has more than one director or more than one producer, they really aren't candidates for a merge field -- but would be good in a calculated field, if you could call them specifically.