I have a table that has a field called 'CODE' which is a 8 digit number. In another table, I have a text field that is the description for the code field (it also has a 'CODE' field).
I have a datacombo box that is populated with the 'CODE' field numbers. What I want is this: When you click the datacombo and scroll down to the code you want, after you select it, I want, on a label next to it, display the appropriate description from the other table. Can anybody give me some advice?