1 Reply Latest reply on Sep 29, 2010 11:10 AM by philmodjunk

    Single Record delete, deleted 625 records

    StevenSiconolfi

      Summary

      Single Record delete, deleted 625 records

      Product

      FileMaker Pro

      Version

      FM 11 ADVANCE

      Operating system version

      MAC OS 10.6.4

      Description of the issue

      On FM 11 Pro Adv.  I was deleting a single record and a pop-up window came up that said "Gathering Records"  it then proceeded to delete 625 records (all linked by one common field).   I was really annoyed.  I copied my back up and tried again.  it happened again.

      Steps to reproduce the problem

      SELECTED DELETE SINGLE RECORD

      Expected result

      DELETE ONE RECORD

      Actual result

      645 RECORDS DELETED

        • 1. Re: Single Record delete, deleted 625 records
          philmodjunk

          Open manage | Database | Relationships

          Find the line linking these two tables and double click it. Clear the option at the bottom of this dialog titled "Delete related records in this table when a record is deleted in the other table."

          You may have multiple relationships to check as any two linked table occurrences with the same two data source tables may have this option enabled.

          The other work around is to change the value of the field used to link this record to the related records first so that there are no related records, then delete the record.

          This option is very useful in many database designs as you often want the related records to be deleted from a child table when you delete their parent record.