>Hi All,
>
>I have a routine that based on a condition changing the
>color grid's row.
>
>If I have 4 conditions thus , in 20 rows I may have colors scattered all
>over. I would like to create an index so all will shown together.
>
>I wonder if it is possible to index on this routine somehow.
>I created a fields called status and index on so Red is 1 yellow
>is 2, but it requires too much of a maintenance, and may be there is
>another way.
>
>The following is a sample condition code, that is fired via the
>DynamicBackColor property of the grid:
>
>
>DO CASE
> CASE PctDist.lPct_Cancelled
> *** Blue
> *** If Cancelled=
> RETURN RGB(0,255,255)
> CASE dSystemDate> ***Yellow
> *** For future LDI
> RETURN RGB(255,255,0)
>ENSCASE

Sorry, I have to add one more thing. I tried it, it works OK when indexed on procedure from system procedure file (as expected), but for some reason generates an error when indexed on form.method. So, it might be better for you to use procedure.

Edward Pikman
Independent Consultant