- Find something that uniquely identifies the record
- Set Validation on that field that it must be unique
- Import the records. FM will reject any that do not pass the Validation.
It worked. Thank you.
Here is how I did it, following the advice given by Sorbsbuster.
In my data base and in the data source I had a unique identifier number. I went into manage data base, found the field for the ID number, went into options, then clicked validate. Under the heading Validate data in this field, I clicked the "always" radio button and then under the heading "Require:" I checked "unique value" . Then went to File, Import Records, from File, selected the comma delimited data source file. After making sure all the fields matched up, I clicked "add new records" and made sure to select the "do not import first row" option. Then clicked import.
Hope this is what you were looking for.
Thank you so much Allison.
I really appritiate your help.