Delete from one to many

[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

 

[Duane Hookom]

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.

 

[JethroUK©]

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

 

[Duane Hookom]

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.