Duplicate Records

[jyanks]

So I have a Sales Log form that takes the following input:

Shift ID
Gender of Patron
Product ID
Qty
Total Sale

I want to add two things to the form's functionality:
1. Add a button that creates another record with the same Shift ID, and
Gender of Patron (So that someone could easily put in several items for the
same person), OR, how would I go about creating a form that creates several
records at once with the same Shift ID, Gender, but with different products,
qtys, and total sales.

A sample form design of the latter would be something like this:

[Shift ID Input]
[Patron Gender]
[Record 1 Product ID] [Record 1 QTY] [Record 1 Total Sale]
[Record 2 Product ID] [Record 2 QTY] [Record 2 Total Sale]
[Record 3 Product ID] [Record 3 QTY] [Record 3 Total Sale]
etc.

2. How would I go about having some sort of 'autofill' functionality with
the text boxes? If Product and Product QTY have been filled in, I'd like the
form to pull price information from the ProductInfo table so that the total
sale text box fills in automatically.

For example, a user enters:
Shift: 12/25/08
Gender: Male
Product: Xmas Tree
Qty: 3
'when user gets here, we know this product sells for 12 dollars each, so
when the focus goes to the next text box, total sale amount, the form would
know to fill in the box with $36 automatically
Total Sale: 36.00


Any way to go about doing either of these things?

 

[Mike Painter]

So I have a Sales Log form that takes the following input:

Shift ID
Gender of Patron
Product ID
Qty
Total Sale

I want to add two things to the form's functionality:
1. Add a button that creates another record with the same Shift ID,
and Gender of Patron (So that someone could easily put in several
items for the same person), OR, how would I go about creating a form
that creates several records at once with the same Shift ID, Gender,
but with different products, qtys, and total sales.

A sample form design of the latter would be something like this:

[Shift ID Input]
[Patron Gender]
[Record 1 Product ID] [Record 1 QTY] [Record 1 Total Sale]
[Record 2 Product ID] [Record 2 QTY] [Record 2 Total Sale]
[Record 3 Product ID] [Record 3 QTY] [Record 3 Total Sale]
etc.

The first two fields would be on a form and the rest on a subform.
The subform might have a combobox for the products and [Record Total Sale]
should be calculated.

The Northwind database has *very* similar examples.