Deleting record on a form

[Kruppy]

I have a Db for an ambulance service. It has 4 main tables. ALL names have a
record in the ID table. They also could have a record in any combination of
Patient, Member, or Volunteer tables. Each of the associated (Pat, Vol, Mem)
tables has a 1 to 1 relationship with the ID table.
If, for example, I'm in the Member table; 1 ID record and 1 Member record is
displayed. If I delete the record what I want is to delete the Member record
only. Records in the ID table are NEVER deleted.
Access seems to want to delete both the ID and the Member record.

 

[Arvin Meyer [MVP]]

Do you have Cascade Deletes turned on in the Relationships window? If so
turn it off.