Solved: Cascading Deletes

[jauner]

I noticed access will not enforce referential integrity on one-to-one relationship.

Is there an easy way when you delete the main form record it deletes the underlying records?

I have never done multiple table deletes in a query or SQL situation so please help.

[OBP]

You should establish why Access will not allow "Referential Integrity", it sounds as if you either have duplicate or orphan records.
Run a duplicates and an orphan query to identify the rogue records.
Once Referential Integrity is established you can cascade deletions.