Importing related records
Trying to find a way to import records into a related file.
I have an auto parts inventory file with Item ID as the related field. The related table is a Fits file (applications). A co-worker using a clone of my databases has created more Fits records (new records not changes to existing records). I need to import that info into my Fits file and show in the main inventory file through the portal.
Is this possible and how?
My main problem is with the Item ID. It cannot duplicate and I want to add records to the related file. Updating won't add only modify existing.