Mike,
This will no doubt work, but my problem is something different. User wants multiple
Column sort. Like he will CLICK on Company then Account code Then Due Date and so on....
So that is not single sorting like on company or account code, But he wants it should sort
first on company then Account code Then ... whatever he clicks.
first time it will sort on company Index on company tag tmp1
then company+account code index on company+AccountCode tag tmp1
then company+account code+due date. Index on Company+ AccountCode+DToS(DueDate) Tag Tmp1

And that also any field will be ascending or descending eg.
1) Company C(05) Ascending
AccountCode C(05) Ascending
DueDate D Descending <--
OR
2) Company C(05) Ascending
AccountCode C(05) Descending <--
DueDate D Ascending

Hope u will understand my problem.

Regards
Amit

>Okay, bear in mind that this is mostly conceptual. You can choose to implement this in your classes.
>
>1 - Open view in form's data environment and set NoDataOnLoad to .T.
>
>or
>
>in Form.Load
>use yourview nodata
>
>2 - in Form.Load
>
>select yourview
>index on tag
>index on tag
>
>3 - in grid.column1.header1
>
>set order to tag
>THIS.PARENT.PARENT.REFRESH()
>
>in grid.column2.header2
>
>set order to tag
>THIS.PARENT.PARENT.REFRESH()
>
>HTH