Delete from one to many

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

I have a form based on one (student) to many (quals) query

What's best method for deleting a student record or a quals record (assuming
it can be done at all)

I assume i need two delete buttons for starters
 
The command button wizard can create this for you. If you have correctly set
referential integrity, your child records will be deleted when the parent
record is deleted.
 
I was really wondering how to delete a record - when i tried this in the
query itsself - it deleted the record fine - but the record reappeared when
i ran the query again (assuming it's because of the relationship) - however
it behaves totally differently when the same query is on the form - it
deletes from the many (quals) half of the query until there's only one left
and then it deletes the parent - which is perfect

my question now i supose is - this sounds too good to be true - so is it?
is there something blindingly obvious that i've overlooked
 
In a form of students and quals, I would expect the student record to be on
the main form and the student/quals to be on a subform. Deleting a record
from the subform would have no affect on the student record.

You will need to test your queries and forms based on how you have them
designed.
 
Back
Top