SERIOUS ERROR when importing updating matching records in found set,
Description of the issue
Today I attempted to import records from .xls into FMP Server 8.5. I set it up to update matching records in found set, add remaining data as new records. I used the email address as my matching field and requested to update 4 other fields. The result was elimination of many existing records, inconsistent omission of data in selected fields and elimination of data in existing but unselected fields. Example: In master DB I have a guy named Matt Kunz, email addy: email@example.com In the data I imported, his email address was firstname.lastname@example.org, first name, last name etc. My expectation was that I'd be able to search for Matt Kunz or any other person, and if a matching email didn't exist, they'd now have two records, the original and the new data associated with the unmatching email address. INSTEAD, when I search for Matt Kunz all I get is one record with his imported email address and data. HELP!! I can send you the screen shot of what my import screen looks like, I did it right and I made copies of the DB and was able to duplicate the error.