If you have created relationships, you need to force Referential Integrity.
Open the Relationships window, double-click the line between the tables, and
check Enforce Referential Integrity. You may also check and Cascade Update
and Cascade Delete.
Press F1 and in the Answer Wizard type About relationships in an Access
database.

--
Marin Kostov
Microsoft Office XP Master Instructor