Summary Field That Calculates Fields From Other Table Or File

[neldom]

I have been trying to come out with a summary field that totals i.e.

"total amount owed" from another file or database.

I could script it, copy and paste, but since files are related I just wanted to know if there is anyone that has tried to do this before.

thanks in advance