>>Although of course you *can* use code to create a view if you want to ... and it's necessary for certain complicated JOIN conditions.
>>
>>For more info on doing it in code see the Help topic for CREATE SQL VIEW.
>>
>>-Rich.
>>
>Hey Rich;
>Could you send me a small sample of code that would show me how
>to use create view and use the complicated JOIN conditions you
>are talking about.
>thanks
Try creating a view using the designer and then run GENDBC (in the tools folder). This will generate a prg which can re-generate the whold dbc including the view. Take out the bit you need to create your view. Cheating, I know but that's how I first learned to program many many many years ago.