Insert field from query into table

[MoeJohnson]

I have a passthrough query that has an item # field and a customer item # field. I also have a table with customer order information that has the customer item #. I want to have the customer order table look up the appropriate item # based on the customer item # it has. what would be the best way to do this? Thanks

 

[PHV]

You may JOIN a table and a query.
What is the problem ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886