>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
Default datasession (Form Datasession = 1)
In forms do not close any tables then and instead of 'use' use 'select AliasName' to switch a table if needed. Beware pointer would be moving for all of your forms.
Cetin