Hi Steve,

Thanks for the reply, after checking my initial post I realized I explained a bit wrong.

This view I am talking about has 2 tables (diagram pane). From these 2 tables I have a few columns selected that belong to these tables (criteria pane). In the criteria pane there also an insert statement under the column column. Then in the sql pane I have that select statement I posted earlier. When this is executed, it returns the results into insert statements which then needs to be run separately. I want to know if I can somehow edit that script to automatically execute the insert results.

Also, I have created a test database so I can play around a bit. Just so everyone knows I'm not asking them to do my job for me. I am here to learn 🙂