@MacroPod,
Thanks for the posting and that he task can be completed. However, using your example files and extending the data for a larger merge, I see that it is a slow process.
Tested at 25 Clients and took several minutes. My target merge will have ~800 "clients"
It appears that during the merge, the DATABASE field is reconnecting to the table to run the new query.
I like the DATABASE field method, however, would you suggest a different methodology for larger merges?
Best speed method?