>In the data environment, put all the tables that you want to use. Then make the relations between them. In your grid, make your control sources table.field, for whichever tables and fields you want. I think that's it.


Well if you create permanent relationships between your tables in the database first, then add them to the dataenvironment, the relations appear automatically.

Some people prefer to set up relationships programmatically in some cases, or use views for child tables rather than accessing them directly though.