Pete -

If you're spawning records (great term!), are you familiar with the
query-cross-product method of generating records?  You start with a
table containing, say, 10 (or 100) records, with a single number field,
numbered from 1 to 10 (or 100).  There are no other fields in the table.
Following the lead of the person who showed my this trick, I usually
call this table "Iotas", and name the field "Iota".  How many records
you seed the table with depends on how many records you are likely to
need to generate.

Now, with this table containing 10 records, if I want to generate 100
records, I use a query that includes the table twice, with no joins
between the two tables, like this:

   qryMake100Records:
       SELECT [A].[Iota]+(10*[B].[Iota]) AS Iota
       FROM Iotas AS A, Iotas AS B;

If I need 1000 records, I include the table three times:

   qryMake1000Records:
       SELECT [A].[Iota]+(10*[B].[Iota])]+(100*[C].[Iota]) AS Iota
       FROM Iotas AS A, Iotas AS B, Iotas AS C;

By including the appropriate "Iotas" query in other queries, I can
generate as many records as I want.  The final query may or may not use
the actual Iota field for anything.  I don't remember who showed me
this, but I've found it quite handy.