Requisition form

[HubbyMax]

I have designed a Requisition form to record products delivered to customers.
My problem is that I can only include 1 input line for products delivered.

Quantity Ordered, Unit Type, Product Number, Product Description, Quantity
Issued

How do I enter more than 1 item for the same for the same Requisition and
have all items saved to the tabe as being part of the same Requisition?

 

[HubbyMax]

I have redesigned the main form using a sub form that allows me to enter the
different items. Now my problem is that when I do enter new items in the sub
form they are not saved to the table including the info on the main form. The
main form and the sub form are joined on the requisition number. Example:

Main form collects all information on the requester, Sub form collects the
information on what that requester orders. Main form info is saved and
contains the Requisition number. The sub form "Requisition number" field
updates to the Req number on main form and I enter the items requested. The
Table ends up with 1 entry for info contained on the main form and 2 or 3
entries containing the items they want. All these entries contain the Req.
number but I want the entries for the items to include teh Main form infor
not have the main form info as a seperate record.

 

[Keven Denen]

I have redesigned the main form using a sub form that allows me to enter the
different items. Now my problem is that when I do enter new items in the sub
form they are not saved to the table including the info on the main form.The
main form and the sub form are joined on the requisition number. Example:

Main form collects all information on the requester, Sub form collects the
information on what that requester orders. Main form info is saved and
contains the Requisition number. The sub form "Requisition number" field
updates to the Req number on main form and I enter the items requested. The
Table ends up with 1 entry for info contained on the main form and 2 or 3
entries containing the items they want. All these entries contain the Req..
number but I want the entries for the items to include teh Main form infor
not have the main form info as a seperate record.







- Show quoted text -

"I want the entries for the items to include teh Main form info"

No you don't. One of the basic rules of database normalization is to
only store data once. You already have the data from the main form
stored and you have a link that connects the main form to the subform.
Why do you want to store the main form data with the subform data?

 

[Keven Denen]

I have redesigned the main form using a sub form that allows me to enter the
different items. Now my problem is that when I do enter new items in the sub
form they are not saved to the table including the info on the main form.The
main form and the sub form are joined on the requisition number. Example:

Main form collects all information on the requester, Sub form collects the
information on what that requester orders. Main form info is saved and
contains the Requisition number. The sub form "Requisition number" field
updates to the Req number on main form and I enter the items requested. The
Table ends up with 1 entry for info contained on the main form and 2 or 3
entries containing the items they want. All these entries contain the Req..
number but I want the entries for the items to include teh Main form infor
not have the main form info as a seperate record.







- Show quoted text -

"I want the entries for the items to include teh Main form infor"

No you don't. One of the basic rules of database normalization is to
only store data once. You already have the data from the main form
stored and you have a link that connects the main form to the
subform.
Why do you want to store the main form data with the subform data?

In this case you have a 1 to Many relationship between the requestor
and the requisition. These pieces of data should be in two separate
tables, linked together by some unique ID for the requestor. I would
suggest doing some research on database design before continuing with
your project.

Keven Denen