Updating based on results from recordset
I'm a bit stuck and not sure I'm approaching the problem correctly. I have a page that displays a recordset. The recordset has a number of joins and subselects and displays a count for each row. I would like to now update a table based on the contents of the recordset. So this is a multi-record update to a table based on all of the records returned by the recordset. I read the WA documentation about multi-record updates, but from what I read this applies to text entry fields only. I didn't see a way to use the multi-record update server behavior to update all records based on the recordset and was confused by the need to specify a number of iterations if the number of records is unknown. Help!
Ideally, I would have the page update the table with results from the recordset upon page load and not even show the user anything but I'm not seeing a way to do that easily.