If you have crafted your new recordset in DW then you should be able to get to the bindings from the application panel under bindings. In here you should see your RS and be able to expand it. You can just drag and drop the column where you would like to see that value on your page. If yo select a form element you can bind the value to that element by selecting and clicking on the bind button below the bindings.
You should be fine to use your new recordset, however it is not the recordset that the search will be applied to. You would need to manually apply the DataAssist Search server behavior to this recordset.