Multiple-to-Multiple List Boxes (repost complete)

[cstanley]

Multiple-to-Multiple List Boxes
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 1
B 1
C 1
D 2


Not all at once, but I want to be able to assign the list box selection to more than one record... how to do?

Thanks,

Chris

 

[Adrianna]

Chris,
You have the option to edit your posts...and reply to your own post. I would not suggest starting a new thread just because you need to ad something new. You're going to confuse the people who will try to help you...and clutter up the forum.

I would help you, but i don't really understand what you're trying to explain.

 

[cstanley]

What can I explain? Can someone else help?

 

[vangogh228]

Try explaining what the database does, what kind of data is in it, what you are trying to accomplish specifically. The example you give is far too vague for someone who is not working on your database to understand it.