Too many subforms in one form?

  • Thread starter Thread starter Jill
  • Start date Start date
J

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
 
Or would a tab control work better? Will the ID be carried forth from the
parent to the children? :-)

Jill
 
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.
 
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!
 
You are quite welcome.

--
Lynn Trapp


Jill said:
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!
Click to expand...
 
Back
Top