I have two tables. One of borrowers, the other of items. One borrower can borrow multiple items. When items have been returned, they are ticked and date returned filled in.
These returned items need to be deleted at the end of the month.
I am trying to set up a delete query that will do the following:
1. Delete borrower and items as long as all items have been marked returned
2. Only delete the returned items and not the borrower if there are still items borrowed
3. Delete borrower if there are no items borrowed at all.
Probably something simple that's staring me in the face but I can't work it out. Can anyone help?
Thanks
Alistair