Re: Forms 5, Summary items TOO SLOW!!!

How about an approach where you only do a net change on the summary. For example, would something like this work?...

1. have a control item for displaying the summary.
2. At execute query time, run a separate query to return the sum/total. Do this once. then populate the control item.
3. Have a trigger on the displayed items so that when the user changes the value, you intercept the action, figure out the net difference, and update the control item which contains the total from the summary query you ran only once.

A lot of work maybe, to figure all this out, but it might be really fast....

good Luck,
Robert Proffitt

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 24 1999 - 20:54:20 CEST