Adding new entries in a many to many relationship

[wistreasures]

Hello all,

This is probably an amatuer-type of question but it has been awhile since I've done much with Access. I have a small database consisting of 4 tables. Technical equipment, people, software and a joiner table for the many to many relationship between equipment and software. I am trying to make a form so that I can pull up a specific equipment ID and then pick the software from a drop down list and click an add button. I guess basically I'm not really sure how to assign a task to a button so that it will add records to the database. Any help on this would be much appreciated. Thanks.

 

[fugifox]

Base your form on a query of the join table.
Then change the textbox field "equipment ID" of your form to a combobox,
and set its rowsource type propety to query
which should contain the relative fields of your equipment table.
The SQL syntax should look something like Select Equipment.EquipmentID, Equipment.Equipment FROM Equipments.
Make the same for the Software field.
Now you have two comboboxes which get data from the tables software and equipment
and store the data to the join table.