Delete Query

[AN60]

Being a tidy type of person I like to clean out every now & then. I have a delete query & wish to know a little more about it before I hit the OK button & put the broom through. I have created the query to delete the many side of a one to many, using parameters date and event, will this successfully delete the links to the one side too? Can a delete query be run from a form (just to make it kook nice)?
Other than have good backups is there anything I should be aware of?

 

[aphelps]

I have created the query to delete the many side of a one to many, using parameters date and event, will this successfully delete the links to the one side too?

Are you asking if it will delete the records in the "one" table? Because it won't. If you want it to, you should set your RI to cascade delete, and run the delete query on the "one" table...I think. That should delete the record in the "one" table, and any related records in the "many" table.

Can a delete query be run from a form (just to make it kook nice)?

Sure, any query should be able to be run from a form. I've not done it, but I see no reason why you couldn't point a button at a delete query, same as any other.