Single field (lookup) from one database to another database into repeating fields
Hi! I am using FMP 9 . I am linking 3 different databases. Basically its a" many(2) to one relational database". And I've come across
a problem. In the one(receiving) database i have repeating fields. Using a unique ID I am able to get data, but
so far I can only get the first row of repeating fields to receive ( repeating fields - calculation w/ lookup function ). Any Ideas?
Best option is to not use repeating fields as only the first repetition will look up a value. A related table of records with one record for each repetition is likely to be a better approach.