Combo box...

  
Hi All,

i have to show two values in combo box(drop down list), Item Name And Item Number,Name with unique number like this ( ABC-70505 )

any help will be highly appreaciated...

Regards
Israr...
Hello Israr,

Create an Output structure with atributes Id and Label, for example.
Set that structure as the output of an advanced query.

Do the query to select the items for the dropdown, and concatenate the fields you want to show.
Eg. SELECT ITM.ID, ITM.NAME + CONVERT(VARCHAR,ITM.NUMBER) FROM ITM

Then use that query and structure in your dropdown :)
 Hi Antonio

thank you so much for Reply,

and i have done it,with simple query...Great

Regards

Israr