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