related records being deleted
I am importing records from an old products file into a new file with a product tables and creating related records. The import is based on updating matching records and adding new records, the matching field is a serialized key.
The old products file has records that are constantly added and updated. For some reason in the new products file the realted records get deleted anytime the record is modified in the old products file. Is this how it is supposed to work? I thought it would only update the records in the product table.