Multi-Column Combo Boxes
I would like create a multi-column combo box in a form that looks up Social Security Number and the associated first and last name. I want the SSN to show up in the SSN field of the form, and then I want to keep this field information as part of the new record. I also want the first and last name to be displayed in the form, but I do not need to save this information as part of the new record. the form has the following records:
The underlying record has all of the above fieds, except the First Name and Last Name.
How do I create the objects on the form that will display the First Name and Last Name with the associated SSN.