TDBComboBox question

[simpleton]

Hey all,

I am using a TDBComboBox to display data (linked to a database) on a userform. I have a field called 'Cust#' and one called 'CustName' in the box. The bound column is set for CustName (which needs to be displayed in the box after user selection) but there can be multiple Cust# values for each CustName.

i.e. Cust# CustName
123 Company A
4567 Company A
999 Company A
222 Company B
... and so on...

My question is, for a given customer name, how can I allow the user to select any of the associated cust #'s with it? Regardless of which row I select, the bookmark always chooses the very first instance of that customer name (like if I choose the row with Cust# 4567/Company A, the bookmark returned to me is that of Cust# 123/Company A).

Any help would be greatly appreciated...

[Jimmer]

I would say instead of using the TDBComboBox, use the TDBList Control and list the possible selections and merge the company field in the list so that they can see the possible selection for each different company.

Hope this helps.

[simpleton]

Thanks