Multi Column Select Lists - Define which column is the stored value
In a multi-column select list, these are used as "Helpers" for the user to select a value from an SQL DB. If the user types the name from the first column, we want to provide five other columns to help them identify which one they want, things like address, active/inactive etc. I want to be able to allow them to select the one they want BUT only return or store when indexing the value in the 4th column, for Vendor ID and not the name they searched by in column 1.
In short - Would like to have definable columns to use when multiple columns are present.