I have 3 tables, Client, Certification, Grant.
Certification has 2 lookups, 1 to Client, the other to Grant. The 3rd is a currency field Cost.
Client & Grant have Service Total column that is a Roll-Up summing up the associated records.
They are set up IDENTICAL but the Grant is not calculating.
I have created maybe 10 roll-up columns so I am not exceeding the 100 limit. I have clicked the recalculate button on the form and nothing. The Client updates but the Grant does nothing. They are all Currency fields. I have attempted to delete them and recreate them as well. Any guidance is extremely appreciated.