Tom,

I always put the Table/Query (and transaction, if
used as non-default) on the form where it is
specifically used. In the datamodule I place tables,
or querys that will be needed application-wide. That
way any resources that I need for a given form are
only created/used when that form is created. Any
resources that are needed during the whole life cycle
of the app are left _open_ during the datamodule(s)
life-time...

Regards,
Steve Fields