>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"
>
>.... 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.
For alphabetical order try
SELECT cSpCatName, ;
nSpCatKey, ;
lower(cSpCatName);
FROM SponCategory;
ORDER BY 3
Then Bound your Combo to Column 2
This will display your character field to your users and save the numeric key in your table. HTH