Why is it that when I try to delete a record in a recordset where I have a join between two tables it gives me a foreign key constraint error, but delete's the record anyway? How do I get rid of the error?

For example:

This is my sql statement that generates my recordset.

SELECT Injury.*, Members.LastName FROM Injury INNER JOIN Members ON Injury.IDNumber = Members.IDNumber

I can add and edit records just fine, but when I try to delete a record I get this error:

Run-time error '-2147217873(80040e2f)':

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_Injury_Members'. THe conflict occurred in database 'RS', table 'Injury', column 'IDNumber'.

Any ideas?