I am trying to update a set of customer records in my FM solution from a MYOB exported csv file.
I have a small customer table that has about 1025 records. If I import from the csv file, no matter which field I match on, I always get pretty much, a full set of duplicate records. (most of the records that I am importing should be in the customer table already).
If I do this the other way round, i.e. bring the csv data into an empty customer table, then import file from a recent backup of the Production Data customer table, I see a result that I would expect - matched records updated and remaining records added as new records.
I both cases I do a show all before the import.
What am I missing??