Too many subforms in one form?

[Jill]

Hi,

I think I've got my tables down... Now, here's my situation. I have
t_PondSampleData with a PK of PondSampleDataID that hinges on pond name
(PondID) and date. This table contains general data (e.g., maximum pond
depth, sampler, aerators on or off).

Then I have 5 tables of more specific data, all linked to the pond sample
data table by way of foreign keys. My question is, what is the best way to
create data entry forms? I need for the PondSampleDataID to carry from the
main table forth to these more specific tables and I see that creating a
subform within the form is one way. However, does this mean FIVE subforms on
the one form?

Jill

 

[Jill]

Or would a tab control work better? Will the ID be carried forth from the
parent to the children?

Jill

 

[Lynn Trapp]

A tab control should work fine for this and, yes, the ID from the main form
will be the means of linking each of the subforms on the tab control.

 

[Jill]

Ahhh, ok, subforms on tab control... I hadn't gotten that far in my thinking
yet but I think I was almost there.

Thank you!

 

[Lynn Trapp]

You are quite welcome.

--
Lynn Trapp

Ahhh, ok, subforms on tab control... I hadn't gotten that far in my thinking
yet but I think I was almost there.

Thank you!