August 31, 200520 yr A client of mine, using a runtime solution I created, added 7 records to the database and entered various data into the available fields. Later she selected one record to delete (Ctrl+E), but when she proceeded, 5 other records also were deleted. I have been unable to duplicate this using my version of the database. Is there a way she could have entered data so that the records were linked/associated in such a way that deleting one would automatically delete others?
August 31, 200520 yr Does the database have a self-join relationship? Check to ensure it's not set to delete related records. Or maybe the client performed a Delete Found Set command, and not Delete Record.
August 31, 200520 yr Author Thanks for responding. There are no self-join relationships and using the client's database I used Ctrl-J to ensured that all records were present, selected Delete Record and multiple records were deleted rather than the one I selected. After I deleted all of the old records and created new ones, I could use the delete record command normally. There appears to be something unique to the records my client had created that results in the multiple deletion problem. I'm stumped.
Create an account or sign in to comment