Brian Fielding
asked on
How to remove (not delete !) a link record from a junction table
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 ?
Thanks
Brian
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 ?
Thanks
Brian
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I thought I would need some DAO to achieve this - which I would be pleased if you could give me a link to a suitable article on this.
Thanks - I have a solution