>>>I have a grid with a recordsource, child order, linkmaster, and relational expr set. I want Column11 to say 'something' if table1.field1 = 'something' else 'somethingelse'.
>>>
>>>How can i vary the controlsource of the column11?
>
>>Look to VFP samples, there is a sample of grid with column that contains >expression as control sourse. Than use 'iif()' function for your case.
>
>I tried in the column11.controlsource properties:
>
>=iif(alltrim(table1.field1) = 'Principal Reduction', table1.field1, this.parent.parent.prin_int_literal)
>
>but it did not like the this.parent.parent.prin_int_literal field which has a alue of 'Prin/Int Payment'. are the form properities not yet defined?
Try to use form property or that purpose, so you can reference it like
thisform.prin_int_literal
In addition, you need to be sure abou scope of 'this' in you expression when it is calculated - just to know how many words 'parent.' include ;)
I don't this they're not defined, because when object created, all other (parent) objects should be created too.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.