If a user attempts to delete a record in a parent table, first it must delete all the related child records and then delete the primary record.

When the user changes the primary key value, Access verifies that the value is unique and changes all related foreign key values in the related child tables to the new value.

You cannot change the primary key value in the primary table that is used in a relationship with another table.

You can add new records, change key fields, or delete related records without worrying about referential integrity.

You will not be enable to delete a record that has related records in another table.