Re: Slow Retrieval in Forms Multi-Block

Ed --

[Quoted] Are the four related blocks detail blocks of a master-detail relation or are they truly correlated on the same level? The reason I ask -- I had a similar issue, and what I ended up doing was deferring the auto-query on the detail blocks in the master-detail relation, and only doing the query "on command" (like for the record that was currently displayed, not for ALL of the records when the user went to a "last record" or a "first record"). It cut my processing time by something like 75%.

Just a thought....

Louise

Ed Jennings wrote in message <3671CD09.661E60E0_at_mindspring.com>...
>I have a multi-block Form that contains relationships from the primary
>block to four other blocks. In addition, there are three data elements
>in the primary block that are pointers to a reference table. I use a
>POST-QUERY trigger to populate non-database fields with the actual
>values from the reference table, so that the display has more meaning to
>the users.
Received on Sat Dec 12 1998 - 18:53:43 CET