>How do I store a sql statement as a view so other forms can access it?
>please email to jhendren@americanabf.com thank you very much

Local View is part of database (dbc file) and can be treated as any dbc component, i.e. you can add view to form.dataenvironment and get DE.cursor.alias to play with.