Happy New Year to all, and sincere wishes for a successful 2002 for everybody!

I am creating a data base to track re-print job orders.
So far, I have created 4 tables and nine forms to manipulate or view the records in these tables. I have created indexes for each table and have related the indexes in the data environment.

Most of the forms use only one table, however one form uses one table for the user to 'enter' data into, and contains a list box which is 'data sourced' to another table, so that the user can choose a record from this table.

Is there a way that a 'data environment' can be created and used across ALL of the forms, so that when any form is opened it will automatically 'see' this data environment, containing all four tables?

I am still very confused about this. Any help in pointing me to a 'eureka moment' would be greatly appreciated.

Thank you!!
Bob Ross