Issue with Combo box wizard

%3CLINGO-SUB%20id%3D%22lingo-sub-1301045%22%20slang%3D%22en-US%22%3EIssue%20with%20Combo%20box%20wizard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301045%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20create%20a%20multicolumn%20drop%20down%20combo%20box%2C%20the%20wizard%20does%20not%20have%20an%20option%20for%20selecting%20which%20of%20the%20multiple%20columns%20I%20would%20like%20to%20capture%20.%20In%20the%20various%20videos%20I%20have%20seen%2C%20there%20should%20be%20a%20screen%20that%20says%20which%20column%20would%20be%20used%20for%20data%20capture!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20various%20screen%20shots%20can%20be%20seen%20in%20the%20PDF%20file%20enclosed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1301045%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20Multi%20column%20issues%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1301123%22%20slang%3D%22en-US%22%3ERe%3A%20Issue%20with%20Combo%20box%20wizard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F154357%22%20target%3D%22_blank%22%3E%40Anil%20Bagga%3C%2FA%3E%26nbsp%3BFirst%2C%20although%20Microsoft%20saw%20fit%20to%20implement%20Lookup%20fields%20in%20%3CEM%3E%3CSTRONG%3Etables%3C%2FSTRONG%3E%3C%2FEM%3E%2C%20most%20experienced%20Access%20developers%20know%20better%20than%20to%20fall%20into%20that%20trap.%20I%20would%20STRONGLY%20advice%20you%20not%20to%20do%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20if%20you%20persist%2C%20the%20bound%20column%20will%20be%20the%20first%20one%2C%20by%20default.%20It%20will%20contain%20the%20Foreign%20Key%20relating%20to%20the%20Primary%20Key%20in%20the%20related%20table.%20That%20is%20also%20the%20only%20valid%20way%20one%20would%20create%20a%20Lookup%20field.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 should be a screen that says which column would be used for data capture!

 

The various screen shots can be seen in the PDF file enclosed.

1 Reply
Highlighted

@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.