>I have a 1-M form for my order entry module. I display calculations at the bottom of the form, which is a total of all the detail items the user entered in the grid. I don't want to use a trigger to update the calcs because that would require a tableupdate to be issued. I am using optimistic table buffering on the grid, but when I attempt to scan or loop through my child table to calculate the curent values, my triggers fire. I want the calcs to update immediately as the use changes info in the grid. I have tried querying the table but it returns the old value. Help!
>
>Thanks.
I tried this; when I use optimistic buffering, I can do whatever I want to the table without the update trigger firing; are you talking about RI?