How do you add multiple records to a table based on the results of a query?

This is probably an easy one:
I am setting a cookie (like a product id (identity)) after inserting into one table, but want to populate the product detail in another table, based on a query with that products standard characteristics (a product master file) before the user makes changes to the product options. I had planned to run a query after the value is set and insert those results into the product detail table. Have done it in access, and the other web dev app I am coming from, but can figure out how to do it automatically in Wappler - am sure it is easy.
Thanks in advance.