What's recordsource of the grid? How recirds are ordered in the recotdsource?

>Using Cetin's idea on dynamicBackcolor, I want to display the information in a grid where 2 backcolor alternated each other, such like single recno or double recno... however, this time is using the date, the records with same date using same backcolor...
>
>IN dynamicbackcolor of the grid
>

>Thisform.pf1.tx.SetAll("dynamicbackcolor",
"IIF(MOD(thisform.getbackcolor(ptt1.tx_date,'ptt1'),2)=0,
RGB(212,237,218),RGB(255,255,255))", "Column")
>

>
>Custom Method: getbackcolor
>

>LPARAMETERS tdate, cTable
>
>DO CASE
>CASE cTable = 'ptt1'
>	SELECT RECNO('tmpvisit1') as a FROM tmpVisit1 INTO CURSOR tmp WHERE tx_date = tdate
>CASE cTable = 'ptt2'
>	SELECT RECNO('tmpvisit2') as a FROM tmpVisit2 INTO CURSOR tmp WHERE tx_date = tdate
>ENDCASE
>
>RETURN tmp.a
>

>
>tmpVisit1 is generated from the ptt1 as follows:
>

>SELECT distinct tx_date from ptt1 into cursor tmpVisit1 order by tx_date
>

>
>However, the backcolor is changing according to tx_date?! what's wrong? Please help