So why do you think this is better than simply using the table and setting a filter for the year?


>Looks right. There are some classes here in the downloads section that you can use for sorting. The user clicks on the column header and the grid is sorted.
>
>>Is this what you had in mind? It works but is not much different from using the tables directly.
>>

>>** grid.init
>>
>>SELECT test_financing.* ;
>>from tip inner join test_financing on tip.tip_id = test_financing.tip_id ;
>>where year = 2007 into cursor crsYear1 readwrite
>>select crsYear1
>>index on tip_id to tempyear1
>>
>>this.RecordSourceType = 1
>>this.RecordSource = "crsYear1"
>>
>>select tip
>>set relation to tip_id into crsYear1 additive
>>
>>this.column1.ControlSource = "amount"
>>this.column2.ControlSource = "source"
>>this.column3.controlsource = "phase"
>>

>>
>>