eliminating duplicates on import (FM6)
We are getting duplicate records when importing from a MsSQL dbase, even though I have set the import to overwrite the record if three fields match.
We have a file of youth basketball players from around the country. When we run tournaments, we get updated info in our website dbase from any players who play in the tournament.
We connect to the dbase and import the player records, setting FM to match FIRST NAME, LAST NAME and ZIP. If these match, the record should be overwritten with the imported data.
But we are getting new records on some imports, even though the existing record and the import record have the same FIRST NAME, LAST NAME and ZIP.