data entry form question

[roma]

Hey,

I'm trying to set up a database and I need some advice on
setting up a data-entry/viewing form. How do I create a
form with a variable number (number, not type) of fields?

Basically, I want a form that allows me to enter
information about "samples" (like sample type, sampling
method, sample analysis, etc) for each "project". The
problem is that I can't predict how many samples the user
will have to enter per project. I know I can create a
separate Samples table and link it to, let's say, a Project
Info table but I am trying to avoid taking this route. I
would like to have all the samples for each project in one
form. Ideally, the user would specify the number of samples
and the form would automatically give him an "n" number of
sets of fields for each sample. Is this possible? If so,
how? These sets of fields would, obviously, all be made up
of the same fields. They would just be repeated as many
times as the number of samples.

Thanks in advance.

 

[Arvin Meyer]

You had the right concept of using a separate table for the samples. Now
include a foreign key field (project id) in the samples table, and use that
table as the source for a subform.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Roma]

Thanks. I was afraid of that. The reason why I was
reluctant to do it was because each project has several
sites and each site several samples. So I will need a
Project Info table linked to a Sites table linked to a
Samples table, which might be a little confusing for the
user to keep track of when entering data. But actually
doing a "main/subform" form will probably solve that problem.

 

[Roma]

hello again,
still regarding my data-entry form question, is it possible
to create a main/subform form with two subforms?
Thanks again