Looking to copy data entered in form to multiple records in the same table.

[katskin12]

Hi,
I am creating a table to track part serialization. It looks like below:

Serial Number	Date	Work Order	Part Number	Heat Treatment	Order Quantity

I created a form to enter that data. The serial number field is the autonumber field used as the record primary. I want to copy data entered in the form in as many records as the order quantity since the information is exactly the same, I just need to tie it to unique serial numbers. Ex. If I have 3 items in the WO, I want to fill out the form and it would result in a table of:

Serial Number	Date	Work Order	Part Number	heat treatment	order quantity
1	4/29/20	1234	Part 1	H1234	3
2	4/29/29	1234	Part 1	H1234	3
3	4/29/20	1234	Part 1	H1234	3

Is there a way to do that? Thank you.

[orange]

The serial number field is the autonumber field used as the record primary.

Do not use the autonumber field for anything other than the PK for the database system itself.

Use your own field and review the concept

SerialNo =Dmax(SerialNo) +1 to get sequential serial numbers.

[Gicu]

You could do something like this, might want to move the inserts to a different event.

Cheers,