Instead of populating the combo with the complete list of names and an ID column (which may not be meaningful to the user), you might consider populating it with a distinct list of names and a column (that isn't displayed) with a count of each name. When the user selects a name, if the count is greater than 1, you might populate a list box with additional information about each person that permits the user to make the correct selection and then take the value from ID field (again not displayed to the user) to retrieve the data needed (similar to dialog displayed in the help for VFP or MSDN when there are multiple topics). In those cases where the count is 1, retrieve the data directly for that record.
In combo boxes and list boxes, columns are hidden from display by setting the ColumnWidth property to 0 (i.e., if you have a two column combo setting the ColumnWidth to 125,0 will hide the second column).
Best wishes,
John
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only