>>I have a grid with a relationship to another table in one of the columns (reference lookup). When the value is not in the lookup, I'd like the blank text to display "Not Available". I tried putting the condition code in the ControlSource but it wouldn't let me. I tried putting it in the grid's Init (as well as the grid.column Init and grid.column.text Init) but it bombed. Where can I put the code?
>You can put an expression in the ControlSource of a grid's column if you enclose the expression in parentheses.
That's interesting, I did try it before and it didn't work (error message read as "The data source for this object must be a variable reference") but now all of a sudden it works. I wonder what went wrong in the first time. Sigh. Thanks so much for your help. Appreciate it! :)
Thanks!
~d
J