troubleshooting Question

How / where can I add records to Junction Table in MS Access ?

Avatar of Brian Fielding
Brian FieldingFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
11 Comments1 Solution1115 ViewsLast Modified:
Am using 2010/13 Access, 32-bit and the basic database structure is:

Clients  1>m  Contracts  1>m   Link   m<1  Scanners  1>m Reports

I'm able to create and add Contract Records and Scanner Records to the appropriate Tables but I cannot work out how to add the link records to the Link table.  Typically a contract has 1 to 3 scanners and I would be grateful if you could tell me which event(s) to use and suitable code (DAO ?) to use to add the links.  The Link table holds the ScannerID and ContractID and am intending adding an insert date to the link.  Some direction on deleting these links would also be useful.

I have searched but have found the best article s are SQL based but a direction to suitable (for beginners !) articles would be appreciated.

Thanks
Brian
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros