Multiple Update of SOME records
Update Multiple Records behavoir.
I'm trying to create a page that will update SOME (but not all) of the records for products listed as part of an order in the OrderDetails table.
I've already created a page that will "multiple update" ALL of the products in a given order and it works well.
(Each product has its own status: Allotted, Backorder, Shipped, etc.)
So if, for instance, I have an order with 5 products with two having Allotted status and three having Backorder status, I might want to "Multiple Update" the two Allotted status products to Shipped status and leave the Backorder status products unchanged.
The trouble is, I've created a page with a recordset and repeating region that lists only the two Allotted status items but when I run the Multiple Update, it updates the status of all five records to Shipped status, including the three Backorder products not shown on the page.
Any idea what I am doing wrong or what I need to do?
Using ASP VB and the latest Data Assist.