Access 2016 -- combo box functionality vs data normalization

%3CLINGO-SUB%20id%3D%22lingo-sub-1174174%22%20slang%3D%22en-US%22%3EAccess%202016%20--%20combo%20box%20functionality%20vs%20data%20normalization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174174%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20--%20new%20member%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20database%20whose%20primary%20table%20tracks%20events%20(primary%20key%20--%20autonumber%20ID)%2C%20which%20have%20locations%2C%20many%20of%20which%20repeat.%26nbsp%3B%20The%20locations%20table%20includes%20a%20LocationID%20and%20the%20text%20Location.%26nbsp%3B%20One%20way%20to%20display%20the%20location%20would%20be%20in%20a%20combo%20box%2C%20with%20Column%20Count%202%2C%20Column%20Widths%200%22%3B%201%22.%26nbsp%3B%20A%20problem%20with%20that%20method%20is%20that%20one%20cannot%20enter%20a%20new%20Location%20(not%20already%20on%20the%20list)%20without%20triggering%20an%20error.%26nbsp%3B%20Thus%2C%20it%20seems%20that%20one%20can%20employ%20good%20data%20practice%20(using%20an%20ID%20in%20the%20Location%20table)%20or%20have%20the%20combo%20box%20function%20of%20adding%20a%20new%20value.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20solution%20to%20this%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoe%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1174174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1174241%22%20slang%3D%22en-US%22%3ERe%3A%20Access%202016%20--%20combo%20box%20functionality%20vs%20data%20normalization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174241%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F557811%22%20target%3D%22_blank%22%3E%40Joe_Root%3C%2FA%3E%20Microsoft%20provides%20a%20nice%20example%20of%20how%20to%20do%20this%20in%20the%20Northwind%20database%20on%20the%20Order%20Details%20form%20in%20the%20Order%20Details%20tab%2C%20field%20Product%20ID.%26nbsp%3B%20You%20should%20be%20able%20to%20do%20this.%26nbsp%3B%20Here%20is%20the%20data%20tab%20settings%20from%20that%20form%2C%20maybe%20you%20need%20to%20change%20one%20of%20the%20settings%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1174450%22%20slang%3D%22en-US%22%3ERe%3A%20Access%202016%20--%20combo%20box%20functionality%20vs%20data%20normalization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174450%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F557811%22%20target%3D%22_blank%22%3E%40Joe_Root%3C%2FA%3E%26nbsp%3BIt's%20a%20question%20of%20data%20entry%2C%20not%20of%20data%20normalization.%20See%20the%20classic%20sample%20db%20Maria%20referenced%20for%20ideas%20on%20how%20to%20handle%20the%20data%20entry.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 the text Location.  One way to display the location would be in a combo box, with Column Count 2, Column Widths 0"; 1".  A problem with that method is that one cannot enter a new Location (not already on the list) without triggering an error.  Thus, it seems that one can employ good data practice (using an ID in the Location table) or have the combo box function of adding a new value.  

 

Is there a solution to this problem?

 

Thanks,

 

Joe

 

 

2 Replies
Highlighted

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

Highlighted

@Joe_Root It's a question of data entry, not of data normalization. See the classic sample db Maria referenced for ideas on how to handle the data entry.