I found the technique of opening new windows through buttons on
another window to be an extremelly efficent way of quickly createing
mutiple related data synced together on the same screen.For Example,
If you have one window displaying, layout A, with data from table A,
in list view and you wish to view other fields relating to the
information from that particular record, it can be stored in table A
and displayed seperately in a new layout B. This enables quick
relations allowing for simpler caclulation, which do not need to be
jumping across tables and the techneque also eliminates unnecessary
relationships while maintaining a slick appearance. Of course not
every field would be jamed in one table but the Window viewing
technique allows for easy connections between for instance,
information pertaining to fields such as OutSideProcesses, Materials
and Treatments belonging to one WorkOrder - these types of fields
would be used in a manufactoring shop process tracking database.
Fields and Tables would vary for accounting and other
organizationaltional tasks depending on avenue of deployment.

it worked for me.

vajra78