I am assisting with an Access Db (2007) that was imported from 2000, and realize I am a beginner the more I learn about Access.
In the Db, there are many tables and forms, but one issue that has arisen - which we haven't been able to resolve - is within some forms. 'I will try to explain as best I can.
They are using a combo box that lists values based on the primary key that joins several other tables together. The problem is, the actual items they need (Column 2) are not in alpha order. For example, Column 1 on the table referenced by Combo box 3 is the primary key - a 2 letter code. The 2nd column is the actual item, the term we want the form field to display in alpha order (as the primary key abbreviations are a formal "code" that may not correspond with the actual item). We tried adding another field, simply 1-87, and then tried to have the form sort by that to no avail. Additionally, we only want Column 1 and 2 to display.
If attaching screenshots would help, I'd be happy to do so. Thank you in advance.
Jim