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