My database contains amongst other things a table of owners and a table for assets. I would like to be able to create a field in the owners table which adds up the capacity field of those assets and displays that in that owner table. I've looked around but can't see any documentation which explains this. I would also ideally like to be able to pull that information into a third view which is contacts and partially made up from the owner table displaying related fields.

Please help

Many Thanks

Simon