A foreign key value can be selected from a descriptive value by specifying the column
lookup property as an SQL statement. The first column selected represents the value assigned to the column being edited and the second column is the descriptive text associated with that value. The sample also demonstrates use of the
multiValueLookupSelectStyle property which can be used to change the style of multi-value selection lookups such as search lookups.