Question Creating data relationships using subforms

[StevenAFC]

Hi all,

I am doing this for a friend, and personally don't have a great deal of expierance using Access!

Basically I have set up 3 tables :

tblEquipment
equipmentID
item (being its name)
room (where its located)

tblExperiment
experimentID
name
date

tblRelationship
relationshipID
equipmentID
experimentID

I have set up relationships between the id's from the 2 tables into tblRelationship.

Basically this database is to list the experiments done, and equipment used.

So now I have created a form which cycles through the experiments, and a subform which shows the equipment used in each experiment. This works great, but I want to be able to add equipment to experiments, this would mean creating a new field in the relationships table.

How can I do this using Access 2007?

 

[StevenAFC]

Update:

I have added a combo box to the subform, which lets me select a record, however when I do so, instead of selecting an existing record it creates a new one.

Even more bizarely, it takes the original equipmentID and sets that as the name of the new one, despite showing the name in the combo box.