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.

>There is no code involved in creating and using a buffered view. You use the view designer to create the view (open the database and select Database|New Local View. Don't forget the check the Send SQL Updates check box in the Update Criteria page).
>
>In the form data environment, you include the view and select BufferModeOverride = Optimistic row/table buffering.
>
>HTH
>
>>Could you give me a small sample in code of what you mean?