Can't import updated records without creating duplicates on MAC
I am using a database with over 8,000 customers' contact information and a relationship graph that links four seasons of concerts with customer sales. I need to update my contact information from QuickBooks to add data about our current season's sales. I do NOT want to rebuild this database. But no matter what I do, I get duplicate records of all past customers. I HAVE a unique field to match. I choose 'Match' and 'Add new'. Is this because I'm using a Mac computer, and so, a limitation of the software? Or is it the drop-down entry fields that are causing the problem as I've gleaned from other posts? NONE of those fields are in the contact information that needs updating (the main table of the database). Note: All I know about FM is from straight trial and lots of errors.