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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Post Exp Date in Master Rcd (row) from trans record 8
When added a record wil automatically can be chosed in other form 2
Change to form 3
Pop-up form that creates record that links 1:1 to main form 0
Posting from a form to a table 2
Access Automatically Send a notification email once a record is added 0
Record insert/delete anomaly 0

Back
Top