Forum Discussion
Access 2016 -- combo box functionality vs data normalization
Hello -- new member I have a database whose primary table tracks events (primary key -- autonumber ID), which have locations, many of which repeat. The locations table includes a LocationID and ...
Joe_Root Microsoft provides a nice example of how to do this in the Northwind database on the Order Details form in the Order Details tab, field Product ID. You should be able to do this. Here is the data tab settings from that form, maybe you need to change one of the settings?