I have a grid mapped to an Oracle remote view. One of the columns is a 1-char field containing either Y or N. I want to control this with a checkbox field, which takes only .T./.F. or 1/0.

I tried adding a calculated field to my view, which has lead to all sorts of headaches, and I have decided that there must be a better way.

Can anyone suggest a nice elegant way to transform this Y/N controlsource into a checkbox ?