Forum Discussion
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 trac...
- File > New and download the Northwind sample app.
Look at the database design: Orders 1:M OrderDetails M:1 Products
Then look at how this M:M is implemented in OrderDetails form: Orders are on the parent form, there is a subform with OrderDetails, and a dropdown with Products.
File > New and download the Northwind sample app.
Look at the database design: Orders 1:M OrderDetails M:1 Products
Then look at how this M:M is implemented in OrderDetails form: Orders are on the parent form, there is a subform with OrderDetails, and a dropdown with Products.
Look at the database design: Orders 1:M OrderDetails M:1 Products
Then look at how this M:M is implemented in OrderDetails form: Orders are on the parent form, there is a subform with OrderDetails, and a dropdown with Products.
Ah, subforms, that's the technique I should use. Thank you.
I already use subforms in my Project Log database, so the timestamped note entries are automatically attached to the project number, but that was a one-to-many relation. I did not realize the same technique could be used on a many-to-many link table.
- An update.
My first form/subform setup for this used the Link Table as its base for both parts. It worked, but I had a copy of the machine-level form for every fuse listed for that machine, with all the listed fuses on each machine-level form.
My second attempt used the Machine Table as the base for the main form, and the Link Table for the subform, and then I got a sane response: one form per machine, all fuses for that machine listed in the ( continuous form) subform.
Thank you again for your help, Tom.
