>I was thinking you could group your tables by date in a temporary cursor using a select command, ordering and indexing it (the cursor) by date.
>Then if you set a relation from The main tables into the cursor, you could
>set the dynamicBackcolor of the grid like that :
>Yourgrid.setall("dynamicBackColor","IIF(mod(recno('GroupCursor'),2)=0,YourFirstcolor,YourSecondColor)","column")
>In this way you should switch between two color as the date change.
Nice idea. Or, if there are few records in the second cursor (say, ~10), you may have another field in this cursor called RGBColor I and have a color there. I used a variation of this idea in several of my applications. The difference is that I have a status field (which is always one of the 5 different values) and a color for each status.
If it's not broken, fix it until it is.
My Blog