General information
Category:
Forms & Form designer
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only