So, on that last point I previously had a forum post about that and came to the conclusion that you cannot next queries and used the array as the intermediary step:
My very first approach was exactly that and I thought it would be quick job. Use the query to populate the subtable but it seems that cannot be done that way.
As you can see, I have been working on this one issue for weeks now and have tried everything