hmm, couldn't get this to work...
kept getting error "expected end of statement"
so i wrote 3 Delete Queries, but every time they run i get an access warning about modifying tables, ordered them in a manner so that the link table is deleted first meaning the relationship error no longer occurs