3 Replies Latest reply on Apr 13, 2012 10:03 AM by philmodjunk

    Deleting Records Issue



      Deleting Records Issue


      When I want to delete 1 record out of the 1000 or so that I have that it wipes out my whole database. I do a search and it finds say 4 records and I click on delete record it wipes out most if not al of the records in my database

        • 1. Re: Deleting Records Issue

          Sounds like you have some delete options set up in your database so that deleting a record in table A deletes related records in Table B. If you get enough of these options specified in different table occurrences, you can get a cascade of deleting records that clears most of the records out of your database.

          • 2. Re: Deleting Records Issue

            WHere do I change these options are they in each relationship or in the menu??

            • 3. Re: Deleting Records Issue

              Start with the layout from which you deleted a record and this "cascade" then took place.

              Open Layout Setup and note the name in "show records from".

              Now open Manage | database | Relationships and find the table occurrence box with this same name.

              Double click each relationship line that links it to other occurrences.

              There's a pair of check boxes marked "delete....". In these dialogs. If you clear any of these that specify a delete in the related occurrences, you can then delete a record on your layout and no cascade will take place.

              This is just a "brute force" fix of the problem. You'll need to analyze the delete settings in all your relationships to figure out which ones you need to keep referential integrity and which should not have been specified.