I am working on a small database in ms_access, and I was wondering if there is a way to create a dynamic value into a field, EG. update another table but the first table will update a field, that lets say, is a sum of all the values on the second.

If anyone is lost by my example please yell at me

- Michael Dawson