Calculate Related field

[Sam Laundon]

I am at a loss on how to do this: I have a related field that I need to calculate the total charged amount of orders in the main database. Each client's orders are stored in a related database (billing::amount). I would like to be able to total the amounts of one found field (amount) in the main database.

Thanks in advance

[dbruggmann]

Hello Sam

I put up a simple sample for your question. I hope I interpreted your problem correctly.

There are other ways for doing summ ups, it depends wholly on your database structure.

TotAmnt.zip