Updating Sum Values Fast in 2 Tables

[ShaunTheSheep]

I have 2 tables in a database, one containing rows of transactions with amounts. The other one i want to display the sum of all the transactions, im using a virtual column in the second table with the formula

=SUM(Main[Amount])

However when i add a transaction in Main, it doesnt update the sum instantly even though the table is instantly changed, what can i do to improve this to make it much faster

Thanks

[James_McFarlane]

Do you have Reset on edit set to TRUE?

[ShaunTheSheep]

Its a Virtual Column, I've just accepted its current speed, which isnt slow but not sure if it can be sped up

[ElliotCar]

Are the 2 tables related using a Ref type? (1 to many relationship)

[Ing_Fred_Fiifi_]

I having the same problem but am using one to many relationship... In a ref type... Any help people

[ShaunTheSheep]

No im not using a Ref type