Can you expand a little on the concept and where I could find more information on it?
this means you have to open the relationships window form access.
meaning, no form, tables, querios or reports are open. then you click the relationships button from the toolbar.
Then you double click the lines that connects your tables in that window and then check the checkbox that says referrential integrity. then 2 more check boxes will be enabled "cascade delete" and "cascade update". Just check on those and click ok.
now everytime a PK is edited or deleted in one table, all the tables that has that PK are updated or deleted as well.