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

From: <>
Date: Mon, 24 May 1999 18:54:20 GMT
Message-ID: <7ic78r$d22$>

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 ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 24 1999 - 20:54:20 CEST

Original text of this message