ComboBox Filter while typing (1 Viewer)

[feinj]

I have a situation where I have a ComboBox with a Key (bound) Column called CustomerID, but the ComboBox is designed to sort the data by a Column called CustomerNo.

Is there any way to get the ComboBox to automatically filter the data presented in the ComboBox by the CustomerNo Column, rather than the CustomerID Column while typing in data?

Any help would be greatly appreciated.

 

[VilaRestal]

I'm not sure I understand

Normally you would do that by setting the first column width to 0cm

e.g. with 2 columns, the 1st and ID field the user doesn;t need to see, the column widths property would be something like 0cm;5cm

The only possible downside to that is it must limit to list if the bound column is 'invisible' in this way

 

[feinj]

Thanks alot. This seems to be working great.