DBAdvSearchEdit question

VCL TMS VCL UI Pack
1

Hello,

I have a question concerning the DBAdvSearchEdit component:

This code will retrieve the customer_no:

customer_no:=DBAdvSearchEdit1.Items[DBAdvSearchEdit1.ItemIndex].Captions[1];

It works well.

But is it possible to do the opposite ? I know the customer_no and I want the DBAdvSearchEdit shows the corresponding name ?

(in this example: column0 is the customer name and column1 the customer_no)

Regards

2

Perform a locate on the dataset on customer_no and use

customer_name:=DBAdvSearchEdit1.Items[DBAdvSearchEdit1.ItemIndex].Captions[0];

?