>Hello Everybody
>
>I have a short question
>
>in foxpro2.6x (dos) can I display more then one field in a dropdown combobox
>
>like vendor and vendor_id in the dropdown part, I don't care if the inactive dropdown box only shows one field, as long as the activate (opened) dropdown box shows more then one field
>
>list in visual foxpro all you have to say is columncount = 2, ya know??????
>
>Thanks


Steve,
FoxPro for DOS doesn't directly support popups lists (FPD's @GET version of a combobox) based on fields in a table. It allows you type in values or base it on an array. You can create an SQL statement to load the array.

SELECT Vendor + " - " + Vender_ID AS PopVar FROM Vendors INTO ARRAY arPop

Then base your popup list on arPop.

You _can_ base a list box or a Popup (Using DEFINE POPUP) on fields in a table. To use multiple fields, put Vendors.Vendor_ID + " - " + Vendors.Vendor in the field box. The list will show both fields. You can use this method to show as many fields as will fit.

You can pull out one field with a LEFT, RIGHT, or SUBSTR.

Final note. We used to simulate a combo box in DOS with a text field and a button. The button would ACTIVATE a POPUP just below the text field. Worked pretty well.