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...