Hi Tom,

>create sql view agents_view as select * from a
>
>I can DO FORM AGETNSFORM which displays the view in the form.
>
>How do I make the connection between subsequent select statements to view the new data in the same form? Select wants to display its data in a BROWSE window. Do I have to CREATE SQL VIEW ... each time and then DELETE VIEW to get different data?
>
>e.g. select * from a where a.contactid = "KOGR"

select * from a where a.contactid = "KOGR" INTO CURSOR MYCURSOR

Will cause the selected records to be placed in a cursor called MYCURSOR and will not cause the Browse window to display.

Have you tried building the View in the View Designer, then Adding the View to the Data Environment and dragging fields from the view on to the form.

That should get you started....

HTH,