Question Retrieve Records from Each Related Table

[khwaja]

I have an access database with a large number of tables with relationship to a parent table. I recently noticed that one record went missing and apparently deleted from the parent table and as a result of this the supplementary data got deleted from every single related table. It has not happened to me a lot but when it does happen it is such a hassle to retrieve info from backup be database. I am sure others may have this issue at some stage. Is there an easy way to retrieve every single related record for a nominated record so that I could use the dump to update to curent copy of the DB.

 

[JANR]

No easy way, you'll create it manually faster if it's only 1 record than several append queries.

To prevent this from happening again go to your relationshipwindow and click on each joinline and uncheck "Cascade Delete", that will prevent this.

The downside to this is that IF you want to delete a parent record you'll have to make delete queries for each of your childtables and run these before you can delete a parent record.

JR

 

[khwaja]

OK thanks. Wish there was a program which could identify related tables and help extract ot append records.

 

[vbaInet]

Just to add that it might be wise to review the way records are deleted so the same problem doesn't arise. For example check if a Parent record exists before allowing the child to be deleted.

 

[khwaja]

Good point. Thanks.