Forms and subforms i think!!

[Guest]

Hi

Wondering if anyone can help

I am currently designing a database from scratch for one of the departments
at work.
They are testing and need to record the results of their tests.
What i had in mind was a first form with a set of fields which will apply
for all samples in the test which then has a subform with each of their
samples
Is this possible or is it easier to have all this data in one form.
Also i have a drop down box for the testers how easy is it to have this drop
down box populate a field in the results table??

 

[tw]

Are they testing multiple instances of one type of thing, or are they
testing multiple instances of multiple types of things?
Do the results apply to the overall sample, or do the results apply to an
individual thing that will later be grouped into a sample with multiple
possible samples? There are many questions to ask before the db design, but
to have a main form that shows to overall results of the sample and a
subform that shows each individual results. What kinds of fields constitute
applying to all samples and which apply to specific samples?

It's very easy to use a combo box just fill in the control source of the
combo box with the name of the field you want populated. The rowsource has
the list or query that will drop down.