Example   Source
  Menu  | 
<<
>>
 |  Run as  
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.