Title

Relationship / Lookup Issue

Post

In FMPro Advanced 11 for windows, I have relationships setup between two databases. When you create a new record and enter first, last and birthday, it looks to the 2nd database, if a match is found, the remaining fields are to be copied to the new record.

It works every time when I import data from a .csv file. It doesn't work when I manually enter records unless, I go to file, manage, relationships, click on the relationship, OK, OK. Then if I retype the last name or the birthdate and tab out of the field, it works for that 1 record and stops again.

The previous person who used/setup the databases used a MAC and when I transfer the files back to him, it works as expected.

Eventhough the relationships were defined, and all the fields showed as lookups in the table design, they'd "forgotten" where to go to lookup the data. I had to edit them all, but one I did it worked as expected.