I have a table (table A) that contains a reverse reference called "AppliedCheques". That contains a list of rows in Table B that point to this row in Table A. I have another column in Table A called "TotalCheques" whose value is set to SUM([AppliedCheques][ChequeAmount]). Using the 'Test' feature I have ascertained that this calculates correctly. But... How do I force Table A to update the TotalCheques column when a matching value changes in Table B? I would have thought this would be simple, but I have now spent three days trying to figure out how to do it! Can anybody put me out of my misery?
LinkedIn
Twitter
