>I’m populating the display values of a drop-down list from a cursor.
>
>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource=""
>SELECT nSpCatKey,cSpCatName FROM SponCategory ORDER BY cSpCatName
>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource="Q_SponCat.cSpCatName"
>
>When the form is displayed the value in SponCatCbo is wrong, if I order by nSpCatKey it’s right. I understand why it’s doing this but I don’t know how I can display the values in alpha order and still display the right value. I’ve tried setting BoundTo=.t. but then the field is empty.
>
>Any help on this would be appreciated.
>
>/Chris

The information you supplied is not complete, so I will guess. It seem to me that you pick-up two fields (Integer and Character) and want to bind your combo on integer, showing ordered Characters in the list portion. You may accomplish these by following settings:
.Rowsourcetype=6
.Rowsource="mycursor.charfield,intfield"
.BoundTo=.T. && it's necessary for bound combos only
.BoundColumn=2
When you create a cursor, order it by character field.