What kind of field is "firstnamelastname"? Is it a calculation field set to return text in both files and do both have exactly the same calculations?
If one is set to return text and the other is set to return number, that might explain this mismatch
"firstnamelastname" is a calculation field set to return text in both files. Both have exactly the same calculations.
Nothing obvious comes to mind. By the total records after import, it would seem that few records actually matched by the value of that field...
Hmmm, just thought of something. What records where in your found set just before you imported the records? With this type of import you usually need to do a show all records first to get all records into the found set. The matching, if I remember correctly, is performed only against the records in your current found set so if you have just a few records in the found set, you'll only be able to match against those few records during the import.
Right, it does seem that some of the records match, maybe about half, but it's unclear to me how FileMaker determines which to match and which to add. And, I make sure to select "show all records" in both files before performing the inport. Thanks again...