Add records to Many-To-Many linked table
Posted on 2008-10-16
I am creating an Access 2007 solution to enter information about Inventors and Patents. One Inventor can have multiple Patents. One Patent can belong to multiple Inventors.
I have set up the many-to-many relationship using link tables.
Inventor table --> InventorID, InventorName fields
Patent table --> PatentID, PatentTitle, FilingDate field
lkInventorPatent --> InventorID, PatentID and pkInvPat(autonum) fields
I need a form for the user to enter Patent information. They need to be able to choose the Inventor(s) that go along with the Patent.
I know the new records need to go into the lkInventorPatent table. I have been trying for two days to make this happen. (This is my first Access assignment ever) I have put a subform on the Patent form with fields from the lkInventorPtent table. I have tried attaching VBA code to events to add records using selections from a listbox on the form. I am missing something really simple here, aren't I?
Can someone please help me with baby steps or a small example DB attachment? This assignment was supposed to take less than a week and I haven't gotten to the Reports yet. :-O