So I have 2 tables with a relationship of 1 to many. How can I assure that if I delete a record on the one side, then all the related ones on the many side are also deleted? I'd like to just have a delete button on my form for the 1 side do it all (which I currently have one that deletes the one side). Is that possible? or any alternative so that both tables stay accurate with each other. I can physically go into either table and delete the record or records that are related in the other table and it lets me do it.. whether or not referential integrity is applied or not. I don't really understand that ... I'm assuming I will have to have a query of some kind to do that, but if it's simpler than that, I'd like that better. I especially don't want to be allowed to have any records in the many side if the 1 side doesn't exist.
I'm still learning this stuff..
Thank you very much!