Still working on my customs compliance database. Thanks for all answers so
far.

Tables:
tblShipments
tblTariffs
tblPOs
tblInvoices
tblAmendments

A shipment can have one or more of all the other entitiies listed above.
For data entry purposes I'd like my users to be able to basically just type
continuously from the shipment data right through to the last amendment.

So, in your experience what's the best way to handle a form with 4 subforms?
A 2x2 subform arrangement perhaps? If I create a tabbed interface, can a
tab order be created that will span those tabs?

Thanks.

I actually have a database with similar characteristics.

tblPersons
tblLocations
tblContactInfo
tblGear

All tables are linked one-to-many by PersonID. tblPersons being the 'one'
and the other tables being the 'many'. My data entry form is based on
tblPersons, then, in a tabbed-array, each tab will have subforms based on
their tables. Two subforms are in form view and the third is in datasheet
view. That is strictly up to you on how you want it to look.

What you are actually asking, though, is not how to make your database more
efficient, but rather how to make it pleasing to look at.

I have a lot of other visual items on my screen, so I chose to 'tab' the
subforms for space reasons. This may not be the case in your situation.

--
Jim Ory


"Ricter" wrote:

> Still working on my customs compliance database. Thanks for all answers so
> far.
>
> Tables:
> tblShipments
> tblTariffs
> tblPOs
> tblInvoices
> tblAmendments
>
> A shipment can have one or more of all the other entitiies listed above.
> For data entry purposes I'd like my users to be able to basically just type
> continuously from the shipment data right through to the last amendment.
>
> So, in your experience what's the best way to handle a form with 4 subforms?
> A 2x2 subform arrangement perhaps? If I create a tabbed interface, can a
> tab order be created that will span those tabs?
>
> Thanks.