i have a invoice form that have a edit table contain 30 columns.

the "amount" is a symbolic field "calculate qty * price * disc%".

Now the speed problem occur when user try to enter more than 50 lines.

As the lines number increase. It getting slower and slower and the poschanged happen in "qty", "price", "disc" columns.

i already disabled the poschanged event and default event. (And my program is part of the speed problem.) But it is still slow.

Please help. Thanks

In the past, have you been able to add more than 50 lines or have you only recently started adding 50 lines?

What version of OpenInsight are you using?

Are the disabled events the only events on this table or only the mostly likely of causing a problem?

Do you have any other symbolic fields tied to database columns or performing XLATE lookups?

In the past the design the form and table is different.

OI 7.2.1

Sorry the "amount" symbolic field i write in previous post is too simplify.

i make the edit table naked, mean left only the symbolic field in the edit table.

The "Amount" symbolic field got "Case", mean that depend on the X column to know how the amount to be calculated.

Amount=qty * price * disc %

Amount=disc % ( disc of above amount )

Amount=sum of above ( get a subtotal )

Amount=Charges ( disc column can act as charges )

Got a Edit Line link to a symbolic field "Total amount" ( sum(amount) )

thanks

View this thread on the Works forum...