Quickly determine number of detail records and add to calculated field
Posted on 2004-08-10
I want to quickly determine the number customers and use that number at the Company level.
Now I solved it in the OnAfterScroll-event of the Company (with SQL)
When loading the company table into a grid this takes forever, because for each record the SQL must execute.
Does anybody know a fast solution for this?
Please supply some code.