Hi Quinn ---

>What do you mean by the dataenvironment??

The DataEnvironment is a form container for tables associated with that form. Edit your form. Hit right-click. Choose Data Environment. All will be revealed :)

>Also, does create sql view only work with databases or can it work with free tables?

A view has to be stored in a database. It's a static query, more-or-less. Lets say you wanted a table that represented all members in the state of Florida for your club. If you wanted to manipulate that result set as a table and map fields to controls in a form, a view is a good idea. The view could be created by:

OPEN DATABASE mydatabase
CREATE VIEW fla_members AS ;
SELECT * FROM members WHERE state = "FL"

After this, you would open "fla_members" as a table.
Is this clearer now??