Replicating records "n" times from one table to another

[Christo Swart]

Hi

I've posted this question a few months ago and received an exellent solution
from John.
Unfortunately I had a system crash and lost the solution in the process.
Please help me again?!

I have a table in which I store stock item details. I may order 125 items of
a particular stock line. The stock line id and the total ordered is stored
in the stock table. Once the stock arrives, I need a separate record for
each of the 125 items because I have to add serial numbers to each item.

How can I replicate the stock item 125 times in another tableso that I can
just key in the serial numbers?

Thanx

Christo

 

[Jeff Boyce]

Christo

Rather than having John or someone else reconstruct suggestions, consider
going to the Google.com site and searching under the msaccess group for
posts with your name.

Good luck

Jeff Boyce
<Access MVP>