Update a Multiple Value Field in an Update Query

[Joana Villas-Boas]

I have a table that contains customer information as well as some categories.
Some customers can have more than one category so I
turned that field into a multi value lookup field. I created a new table
with each of the categories.
I wanted to do an update query to populate the values in the new look up
field from the data that is in the old Categories Field. Only
problem is it doesn't look like Access will allow you to do that type of
query. Any suggestions?

 

[Keith Wilby]

I have a table that contains customer information as well as some
categories.
Some customers can have more than one category so I
turned that field into a multi value lookup field. I created a new table
with each of the categories.
I wanted to do an update query to populate the values in the new look up
field from the data that is in the old Categories Field. Only
problem is it doesn't look like Access will allow you to do that type of
query. Any suggestions?

Don't use the lookup property of a field, use a combo box on a form. Use
your lookup table field as the combo box's row source and the main table
field as its data source.

When manipulating your data you should work with forms bound to your tables
or queries and not directly with the tables.

HTH - Keith.
www.keithwilby.co.uk