I am trying to figure out how to proceed with entering a static set of data into a main table from a sub table or insert query etc.  I was researching insert queries but did not find information for Tables specifically but for Analytics instead.

The data needs to be canned/pre-built then "recalled" and inserted/added into a master table if that block of data is selected (think a purchase with the same group of options like 2lbs. birdseed, 1 bird house, 1 bird bath).

Is that best done in Creator environment and dumped into a master table in Tables?  I need some guidance...