I have four rows listed on a query. This query finds all rows in an object where status = A or B. The list is as follows.
Row1 A
Row2 A
Row3 A
Row4 A
I tick the checkbox for rows 1 and 3, and then press a button at the top of the list that updates the status for the selected rows to B.
The list now looks like:
Row1 B
Row2 A
Row3 B
Row4 A
I then tick the checkbox for rows 1 and 3, and then press another button at the top of the list that updates the status for the selected rows to C.
The list now looks like:
Row2 A
Row4 A
I then tick the checkbox for Row2 and Row4, and press the button that resets the status to B. The list now looks like:
Row1 A
Row2 A
Row3 A
Row4 A
Row1 and Row3 have re-appeared on the list, and I have no idea why. I would have expected the list to look like:
Row2 B
Row4 B
Is there a trick to processing multiple rows from a list, multiple times? I've read the doco, and can't see anything about this. I did include 'number rows', thinking that AwareIM might need an item number to process, but that didn't work.