Multiple entries in one form

[goeppngr]

I am trying to enter production data for three different shifts. I want this
data stored in the same table with each shift containing it's on line for all
fields. See below:

Shift 1 Prod 1 Prod 2 Prod 3
Shift 2 Prod 4 Prod 5 Prod 6
Shift 3 Prod 7 Prod 8 Prod 9

I am having someone enter all this information on one form. I would like
each row above to be stored in its own row in my table. How can I achieve
this?

 

[Rick Brandt]

I am trying to enter production data for three different shifts. I
want this data stored in the same table with each shift containing
it's on line for all fields. See below:

Shift 1 Prod 1 Prod 2 Prod 3
Shift 2 Prod 4 Prod 5 Prod 6
Shift 3 Prod 7 Prod 8 Prod 9

I am having someone enter all this information on one form. I would
like each row above to be stored in its own row in my table. How can
I achieve this?

Continuous view form.

 

[goeppngr]

Thanks. I realized that about 2 seconds ago. Appreciate the help.

I am trying to enter production data for three different shifts. I
want this data stored in the same table with each shift containing

[quoted text clipped - 7 lines]

like each row above to be stored in its own row in my table. How can
I achieve this?

Continuous view form.