Right got it to repeat what I wanted in the end:
Server Connect:
Repeat on the page itself:
The results are repeating as expected but paging simply does not work selecting the same repeat (repeat1 in this example). Obviously as there is no paging data within the repeat step despite the initial query being paged and the output query being paged.
Interesting exercise and as this post has been unlisted one only those that have responded to will get to see. I’ve since had permission to re-structure the databases as I see fit so have lessened the complications considerably so the above is not really required, but still as I mentioned, an interesting exercise in perseverance none the less. Although I did not get the paging to work I can settle my mind now… Well kind of, you know the apple! Bit of London slang there, apple-core (score) 
Thanks all! Just wanted to update this post and shine a light on what was done to achieve a semi-pleasing outcome.
