Skip to Content (Press Enter)
2011-06-30 21-23-51
Khan
1Views
2Comments
Combo box...
Question
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...
0
0
03 Dec 2011
Copy Link
2020-12-07 17-35-54
António Chinita
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 :)
0
0
03 Dec 2011
Copy Link
2011-06-30 21-23-51
Khan
 Hi Antonio

thank you so much for Reply,

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

Regards

Israr
0
0
04 Dec 2011
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.