Creating multiple records from one form

[Guest]

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.

 

[Larry Linson]

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

 

[Guest]

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

 

[Joseph Meehan]

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.

There are two ways of doing this:

One involves keeping the data in the fields you want copied (call them
fields not columns to reduce confusion, we are database here not spreadsheet
) and carrying them forward to any new records.

The other is more selective and you can just use the Control ' (control
key and single quote key) to copy the prior entry into the new field as
needed.

The choice would depend on how often you would be repeating the sales
order # field or whatever. That Control ' can become second nature after a
short while. Using the first system is more likely to result in errors when
you forget to make the change when the data changes.