Deleting record on a form

  • Thread starter Thread starter Kruppy
  • Start date Start date
K

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.
 
Do you have Cascade Deletes turned on in the Relationships window? If so
turn it off.
 
Back
Top