Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting combobox to always display column 2
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00403289
Message ID:
00403399
Views:
14
>I have a table that has PK, LookupCode, Description as three fields. I want a combobox to always display LookupCode when selecting. No matter what I do, it always contains PK.

I do the following when using a combo for foreign keys.

Set the fk to the last column (3 in your case)
Set that as the BoundColumn
Set ColumnCount to 3
Set ColumnWidths to something like 50,100,0 <-- not the fk has zero width
Set Boundto = .T.

You may also want to set ColumnLine = .F.

To load the combo I use a SQL statment in the combo init that fills a custom array property in the combo.

Was that what you were asking for?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform