COMBOBOX AND adding rowsource from one supporting table

[DevAccess]

Hello there

In my combo box, would like to add one column value from supporting table and rest of the value from main table

so like below

customer name ( supporting table ) --> company Id( main table) --> company address ( main table)

why we are saying support table because we just want to display customer name from supporting table and main table is the table wherein we would deal with update/add/delete function.

what would be best way to deal with this situation to have row source of combobox from two different tables.

 

[sneuberg]

Make a query that joins these tables and use that as the row source for the combo box.