AnsweredAssumed Answered

Suspending Updating of Related Fields

Question asked by CCAS on Jan 19, 2016
Latest reply on Jan 19, 2016 by DavidJondreau

The value in a key field of a newly created record in one table results in the updating of records in a dozen or more related tables. With small files, the time consumed by this is unnoticeable, but with larger files it can become show-stopping. I've managed to knock this down to just a bit greater than one second in cases where tables can contain hundreds of thousands of records...But I'd like to reduce this "lag" to near a instantaneous level. Is there a way to turn-off related record updating and restoring it at a later time (such was when data entry is complete)?