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?

Thanks

Brenda