Appending combo box vales to another table

[keith2511]

I have a table that includes a combo box field. The values for this field are selected from a linked table.



When I run an append query to transfer the data to another table, the result is that rather than the value of the combo box field being transferred, the ID of the row containing the selected value is transferred instead.

How to I get the append query to send the values rather than the IDs to the target table?

Thanks

[pbaldy]

Sounds like a lookup field:

http://www.theaccessweb.com/lookupfields.htm

You need to join both tables in your query so you can return the text field.

[keith2511]

Sounds like a lookup field:

http://www.theaccessweb.com/lookupfields.htm

You need to join both tables in your query so you can return the text field.

Thanks, it worked a treat!

[pbaldy]

Happy to help!