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 <-- note 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?
Just a typo fix. I change "not" to "note" on the ColumnWidths Line.
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