I have a database with a junction table:
Clients 1>m Contracts 1>m link m<1 Scanners 1>m reports
Contracts can be added; modified or deleted; this includes adding and removing scanners.
on removing a scanner from a contract I would (I think) need to delete the associated link from the junction table. However, there are reports for scanners which I must keep.
I've setup a couple of forms to enable me to add contracts and scanners but I do not know how to remove scanners from existing contracts. Can the link be updated (delete and add) to move the scanner to an "obsolete contract" - or is there a better way to handle this removal ?