How do I lookup something from a a different table on a data entry form?

[DeMarcus]

Okay, for simplicity's sake, I have a data entry form.

It is bound to tableData.

Inputs are:

ProductID
Customer Name


ProductID is a combo box.

There is another table called tableProduct. In this table, is ProductID and ProductName.

For convenience sake, when a user chooses a ProductID from the combo box, I want it to lookup that ID from tableProduct. However, how can I do this when everything is already bound to tableData?

Thanks in advance.

 

[Mr.K]

In your tableData go to Design view and then to lookup for the ProductID field. There choose Row source type as Table/Query and under Row source specify your query name. Then go to the form delete the previous ProductID field and insert it again from the list. It should be a combo box with values from the query but bound to the Datatable.