Database Integration and Dropdown Lists Follow
For the project I am working on, I added a database connection to an Excel file. This file has two columns, one for a product number and the second for a number that correlates to how information needs to be arranged on the label for said product number. On the data entry form, I have a dropdown list that populates it's list items using this database connection. I see that you can have the Display Text be independent from the Item Value for each list item. Once the user selects an item from the dropdown, is there any way to return the Display Text since I want the Item Value to correlate with the numeric code we use?