Forum Discussion
Anil Bagga
Apr 12, 2020Copper Contributor
Issue with Combo box wizard
When I create a multicolumn drop down combo box, the wizard does not have an option for selecting which of the multiple columns I would like to capture . In the various videos I have seen, there shou...
George Hepworth
Apr 12, 2020Iron Contributor
Anil Bagga First, although Microsoft saw fit to implement Lookup fields in tables, most experienced Access developers know better than to fall into that trap. I would STRONGLY advice you not to do it.
However, if you persist, the bound column will be the first one, by default. It will contain the Foreign Key relating to the Primary Key in the related table. That is also the only valid way one would create a Lookup field.