Thank you Sergey, Alexander and Daniel for the info. Special thanks to Steve, Erik and Barbara for sharing their fine tools.

Alex


>You can try file#9474 eView by Erik Moore, ViewEdit by Steve Sawyer from http://home.twmi.rr.com/ssawyer/intro.html or
>MakeView by Barbara Peisch at http://www.peisch.com/downloads.html
>
>>How does one get around the limitations of the view designer? For example:
>>
>>I am defining a wiew that is a right join, but I want a character field to be character, not null, in the cursor when there was nothing there. Tried using an expression, but don't know how to give it a name. Ideally, I would like to just define the SQL and then define all the "extras" (defining updateable fields etc) graphically. Tried to hack the DBC... oops, it became unretrievably corrupted.
>>
>>TIA,
>>
>>Alex