For the pagination you should try adding that to the page before you alter the recordset. If the recordset is too complex and DW has a hard time recognizing it you will not be able to apply the pagination. If you apply it to the recordset in a simpler fashion you should then be able to make an update to the recordset after you add the pagination.
As for the issue you are having with your current setup please describe a little more about what you would like to have occur on this page from the perspective of the user. If I had a better understanding of what the end goal was I would better be able to help answer some questions that you have about it.