1 Reply Latest reply on Jul 2, 2012 2:23 PM by philmodjunk

    related records being deleted



      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.

        • 1. Re: related records being deleted

          You'll need to describe what you have in more detail. Modifying data in one table, will not modify data in another.

          There are a few exceptions to that, however:

          If you have a relationship between the two tables and you've enabled the "delete" option, deleting a record in one table can delete multiple related records in another.

          If you have Lookups and/or calculaitons that refer to data in another table, modifying the data in one table might result in data in the other table changing.

          You can also get the illusion that records are disappearing if a value used to define a relationship gets changed as this can "break" the relationship link. This is one way, for example, that records can seem to disappear out of a portal.