I need to import records from excel on a daily basis. I need QB to update the existing records if the claim number is the same ( existing Vs imported). However for all the other records that entered manually ( not imported) there will be sometimes same claim ID or sometimes blank ( not unique). I'm not sure how to resolve this issue as the Claim ID in this case will not be unique and can't be set as a key field? any another idea how to resolve this?