Hi Mark,

You are right. First form is private D.S./modaless and others are default D.S./modal. The reason is that the forms are all related (use the same tables) and 1st Form does the searching (finding the desired record(s)) and then displays the detailed info from record selected and prints it if desired.

The new form has a new table added but uses almost all other tables and relationships.

The thing is that I do not understand VFP well enough to make certain decisions relating to open/close of tables.

I would like to have the tables only opened when the forms need them but I don't know what performance impact opening/closing 17 tables would have on the network when many users (10-30) are transversing form to form.

A little program called Main.prg sets read events for all forms. Had problems getting the flow down to go from form to form keeping the same record pointer from the Main Form, to detail, to report (scope next 1).

I could use auto open/auto close on each form, the relationships would be auto set, and then lookup the desired record by the primary key of the main table and all should be well, but don't know the performance impact on the network!!!!!!!

Any suggestions?

Thanks in advance!
Roland...
==============================================================================
>Sound like you are not using private datasessions if your main form DE opens all the tables. Design-wise this is bad. The beauty of using private data sessions in all your forms is that your forms can be independent of all other forms and can be instanciated multiple times. You should also only open the tables or views you need in each form. Each form, by having its own data session, can establish its own table relations and index orders without affections another forms tables relations and orders.
>
>>Hi,
>>
>>When I create a new form in my project and define new textbox etc.; I have no tables to choose fields from.
>>
>>The Database contains all the tables and relationships and the Main Form dataenviroment has all the tables and relationships.
>>
>>What do I need to do so that when I create a new form all the tables are available to choose from.
>>
>>ALSO
>>
>>There's a single table Wizard and a Wizard with a parent table and a child table that creates a grid, but no Multiple tables wizards.
>>
>>Are there any other Wizards that let you create a form with more than one table with relationships? If so, Where!
>>
>>Thanks in advance!
>>Roland...