I can't remember off the top of my head whether Access allows you to specify that deletes should be cascaded on a foreign key. If it does then you need to set that to on.

I don't think it does though and that means you're going to have to handle this from your code. That shouldn't be difficult, whenever you issue a delete against table A you need to issue a similar delete against table B.