I've moved on since this. 1) I had put in the wrong spelling of my table DOH!
2) I've tried another way to get round this that works.

However, as soon as I leave the dynamically coloured grid, its columns revert back to how they were - so I've still lost my "inheritance trail"

In the BeforeRowColChange():

Select PXENTRYCODES
Replace lSELECTED With .F.

In the grid's refresh()

Select PXENTRYCODES
Replace lSELECTED With .T.

This.setall( "dynamicbackcolor", "IIF( PXENTRYCODES.lSELECTED = .F., RGB( 255, 255, 255), RGB( 255,255,128))", "Column")

In the AfterRowColChange():

This.Refresh()

Anybody any idea?


>Luigi
>
>Thanks again for the suggestion. Just 2 things:
>
>1. On starting the form, i get the message "Expression is invalid. Use a vaid expression for DYNAMICBACKCOLOR". I don't understand this as the he command looks fine to me.
>
>2. As suspected, setting the logical field to .F. for all but the current record,
>

Replace lSelected with .F. all

>means the grid loses its focused record and the last row in the grid is selected (and no amount of clicking on a row will prize it off the bottom line.
>
>Any clarrification?
>
>Any other suggestions out there, guys?
>
>TIA
>
>Terry
>
>>Terry,
>>
>>In the parent grid insert a logic field exempl. lselected, in the AfterRowChangeEvent set at .T. that record of parentdbf and all others to .F. in the refresh metod insert
>>
>>

>>thisform.grid1.setall("dynamicbackcolor", "IIF(parentdbf.lselected= .f.,rgb(255,255,255), rgb(249,255,187))", "Column")
>>

>>
>>Luigi