Multiple-to-Multiple List Boxes

[cstanley]

OK, here goes:

I have a list box from one table where I want to select one value and enter this value into multiple fields from another table, i.e. :

List box:

1
2
3
4

Records from other table :

Field 1 Field 2
A 1
B 1
C 1
D 2

Not all at once, but I want to be able to select one value and assign it to multiple records.. how best to do this?

Thanks,

Chris

So, I want to create, for example:

Field 1 Field 2
A