I have an application that keeps track of services that have been given on a prepaid contract. I have a contract table and a service table. I want to keep track of how many services have been given in the contract table. I have a Rollup field in the contract table that references a Link to Another Record field that is also in the contract table.
I recently discovered that although my Link to Another Record field includes all the services that have been given, my Rollup field is off by one. (shows one less service).
Out of 1191 contracts with 1791 services, there are 10 contract records that have an incorrect Rollup field value.
I am looking for ideas on what is causing this. I know there was a bug in early 2025, but most of my errors occurred after that.
Steve