repetitive enties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My form has six entries, but the first two (date & runpack) are the same for
the 50 records that are entered. Is there any way they could enter the date
& runpack only one time and have it save in each record?
 
My form has six entries, but the first two (date & runpack) are the same for
the 50 records that are entered. Is there any way they could enter the date
& runpack only one time and have it save in each record?
Click to expand...

Umm... if you have a one (date & runpack) to many (records)
relationship, might it not be better to model this as a one to many
relationship between two tables - one for the date and runpack, and a
second table with your additional information?

John W. Vinson[MVP]
 
I would still need a "key" to connect the two tables right? - which would be
my runpack number. So I would only be saving inputing the date however many
times?

Also how do I have a form that sends info to two different tables?
 
I would still need a "key" to connect the two tables right? - which would be
my runpack number. So I would only be saving inputing the date however many
times?
Click to expand...

Since I have no idea what a "runpack" is, or how your tables are
structured, all I can say is "I guess so". If there is one and only
one runpack per date, that field could itself be your key.
Also how do I have a form that sends info to two different tables?
Click to expand...

You could use a Form based on the "one" side table (one record per
date) and a Subform based on the "many", using the Runpack as the
master and child link field to automatically fill it into the child
table.

John W. Vinson[MVP]
 
John Vinson said:
Since I have no idea what a "runpack" is, or how your tables are
structured, all I can say is "I guess so". If there is one and only
one runpack per date, that field could itself be your key.
Click to expand...

A runpack is one lot of sweet potatoes (we use a 5 digit number to denote
each lot), and we may run anywhere from one to five lots in a day. Each one
of those lots may have from one to 50 records that go along with it.
You could use a Form based on the "one" side table (one record per
date) and a Subform based on the "many", using the Runpack as the
master and child link field to automatically fill it into the child
table.

John W. Vinson[MVP]
Click to expand...


Fantastic!! Thank you!! I appreciate your knowledge and time.
leah
 
Back
Top