I have a grid based on a remote view created with sql pass through. I add a logical field in the sql statement as the purpose of the grid is to check off the rows that are to be included in a report.

The view is marked .f. for update since all I'm doing is outputing certain records. The problem I'm having is that I want a running total of all the records checked.

I have a form method that does a sql select sum.... based on the logical field. The problem I'm having is that no matter where I put a call to the sum method, the sum doesn't take into account the check / uncheck that just occured. It is based on the check / uncheck before. I.E. the 1st click on the checkbox does nothing, the 2nd click shows the total as the amount from the 1st invoice, the 3rd click shows the total as the amount from 1 + 2, etc.

Anyone have any suggestions? Thanks,

PF