you will still use 2 recordsets for this, the key to making this work is to use a repeat region to show multiple orders and place the details recordset inside the repeat region so that it requires for each order shown on the page
your orders table would need to have a column to mark the orders as processed or.
you would create a recordset to return all orders where the processed column was set to unprocessed.
add the information to the page to show the order on the page and add a repeat region around it.
Next add the order details recordset. The order details recordset will use the OrderID column from the orders recordset as the filter on the detailOrderId column. you will need to manually move the details recordset code so that it is inside the repeat region for the orders recordset
since you are showing all unprocessed orders, you can set the updated behavior to use the processed column as the key column and update all records where processed is equal to unprocessed, to change that column to archived.
