I need some assistance and insight into creating multiple records in
Access from a single record in another table. For instance, I have a
form with two subforms with one used for accumulating the cost of
items purchased to assemble widgets. Once there are several widgets
finished, the other subform is used for indicating the number to be
transferred to a separate inventory table. So the point is that upon
clicking a button on the transfer subform, I need to create the
multiple records based on the number typed.

I have some experience in using the Open Recordset code and probably
could manage to do a one for one record creation, but one record to
many in another table is a little beyond my level. Any information and
assistance will be appreciated. Thanks.

Bolen wrote:


Not sure I followed that, but you can make multiple records
from a single record by using a little utility table.

Create a table (named Numbers) with one integer field (named
Num). Populate this with values 1,2,3, ... up to more than
you will ever need.

Then you can use an append query kind of like this to create
however many records you need:

INSERT INTO inventory (s, a, b, ...)
SELECT Num, f1, f2, ...
FROM yourtable, Numbers
WHERE Num <= [Number of records to create]

--
Marsh