I have a table with two columns in it: a text description and a corresponding numerical code.
I have a form that has a combo-box containing all the text descriptions in it. I am trying to make it so that the user selects a descriptor and Access automatically pulls the corresponding numerical code into another field right next to it. I need to save the specific descriptor and code the user picked into a separate table. Thanks for the help! Sorry, first post, please let me know what other info would be helpful in making this work.