We have a requirement where a drop-down list box would need 2 columns. (Item / Description) I would need to show both columns/fields because the description helps the user pick the correct item. Only the item would be stored in the field. I could use a secondary data source or store the list directly in the form - How can this be done and what is the best approach to accomplish this?
Thanks