Lookup Forms with FlowFields disabled

Eugene

once i had a problem with slow lookup of Item Ledger Entries.
After some analysis it became clear that the flow fields based on "Value Entry" table data were to be blamed.

so in the form 38 "Item Ledger Entries" i check for lookup mode and if it is lookup mode i make flow fields invisible.

Another alternative would be to pass temporary table (pre-filled with required records from a real one) to the lookup form

garak

when the fields are invisible, i mean, they will still calcaulated.

Why you does'nt run your own form :?: when you need the lookup mode

kriki

garak wrote:

when the fields are invisible, i mean, they will still calcaulated.

Not true. Once I had a problem with a flowfield that was 0 all the time. I noticed that it was 0 when it was NOT on the form. But for SQL, it is advised NOT to put flowfields on list-forms, even if they are not visible.