Creating multiple records from one form

D

Diddy

How would I create multiple records in one table from input on one form?

ie:
Table Column one = Sales order #
Table Column two = Item #
Table Column three = Quantity

If the form had a input field for another item and quantity, I would want
that to be input as a new record in the table. On the form, there would only
be one field for the sales order number and multiple fields for items and
quantities - each being their own record once I hit enter.

I hope this makes sense.
 
L

Larry Linson

Diddy said:
How would I create multiple records in
one table from input on one form?

ie:
Table Column one = Sales order #
Table Column two = Item #
Table Column three = Quantity

If the form had a input field for another item
and quantity, I would want that to be input
as a new record in the table. On the form,
there would only be one field for the sales
order number and multiple fields for items
and quantities - each being their own record
once I hit enter.
Click to expand...

I am not quite certain of your table design... Do you have a separate table
for Sales Order, and is the table you describe for Order Detail? If so, I
believe you'll get what you want with a main form using Sales Order as the
RecordSource, and a Subform Control with a form for OrderDetail, using
LinkMasterFields of SalesOrderNumber in the Sales Order Table and
LinkChildFields of SalesOrderNumber in the Order Detail Table.

If you have a different table design than what I describe, please clarify
(and we will discuss whether it might or might not be a good idea to modify
that design).

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP
 
D

Diddy

I have one table with the following columns:
1. Sales Order
2. Item #
3. Quantity

Basically, I want on my form:

A. One field for the Sales Order
B. Multiple fields for the Item and quantities, and if more than one set of
these are used it would create a new record for each set used.

ie. using only one set (item & quantity) would create only one record, using
two sets would create two records, etc.

Thank you very much for your help.

Turk Ries
 
Top