data entry form question

R

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.
 
R

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.
 
R

Roma

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top