newbie
1 Topic
Newbie Question: Form to populate a Link Table.
I am constructing a database to track the fuse inventory in my department, and I am cross referencing the fuse size/rating to the machine(s) that use that fuse. I have a Link Table set up to track the many-to-many relationships, and have confirmed that I can use the table to get a list of fuses, with the machines that use the fuse, and a list of machines, with the fuses that are in the machine. My current headache is in populating the Link Table. I have been doing it 'by hand,' manually entering the Primary Key for the machine and the Primary Key for the fuse into the Link Table. What I would like is a form where I can select the machine from drop-down list A, select the fuse from drop-down list B and hit the 'add fuse' button to append the data pair to the Link Table. Any advice will be humbly accepted. Thank you all for your time and attention.Solved1.2KViews0likes3Comments