Combo box

[Jason Frazer]

I have combo box in a form. the form reference a query.
The query combine data from 2 tables and the query is
updatable. I want my combo mox to display the
field "msds_name" from the query. But when i selecte to
query box i want it to display the list oa "Names" from
the customers table. And save the Name in the
query "msds_name" field. how can i do this?
The relationship between the query and the Cutomers table
is "Name" = "msds_name"

Thanks for your time and help