Update a field with multiple values

[sizemoreg]

Sorry folks, I have been all over the forum, and cannot find a close answer to my issue. Hopefully you can help me out.



I have a table with invoices, I need to assign agents to process the invoices, I want to insert their names from a list I have in another table. I've tried update query, I've tried writing the SQL insert into, and I am not being successful, any help would be greatly appreciated

1st table

Access table inv
assigned to	invoice #
	1
	2
	3
	4
	5
	6
	7
2nd table Access table agents Nancy John Vicki brian The results I need assigned to invoice # Nancy 1 John 2 Vicki 3 brian 4 Nancy 5 John 6 Vicki 7

[June7]

Why don't you do normal data entry?

Otherwise this will require VBA code. If you want code to do this, what are the rules for assigning agents? Just cycle through the agents until all invoices have assignment?

[ssanfu]

Are you doing this in the table or are you using a form?
Hint: you should be using a form. Then you can use a combo box to select the agent.

[sizemoreg]

Thanks folks, I figured it out. my SQL was, for a better term "bassakwards". I'm still at the novice stage, of access 2007

[June7]

What was the solution? How did you accomplish with just a query?