Another Recordset not Updatable question

[Jester1147]

I think im doing something wrong here... i just cant figure out where.

I have two tables in one query. the common field is "Deployer's Name" which is in one table with two other fields in the query. In the other table is the list of equipment they would be issued. now for the equipment table i have the "deployer's Name" field linked (lookup).

what i am trying to do is have this query that will populate both tables but when the for for that population procedure opens up, it opens up to the same initial record based on the field "Deployer's Name"

If i dont have the query to where it just opens up to a blank record its updatable but not with the associated record. If the query is set to pull up that specific record, its not updatable. i want it to where it pulls up the equipment record based on the "Deployer's Name" field.

I hope this makes sense and someone has a clue where to point me.

 

[vbaInet]

Have a look at this first to see if your problem fall into any of these categories:

http://allenbrowne.com/ser-61.html

 

[boblarson]

You need to do things appropriately. You should be using more than a single query.

This sounds like a clear case of a one-to-many situation where you should have a form/subform set up with the main form having to do with the person and then the subform having to do with their issued equipment.

Also, you may not have your tables completely normalized - you have a table for the person, a table for the equipment, and a JUNCTION table for assigning specific equipment to a person.