calculation total of a field

[Himitsu]

I have been looking through this forum for an answer to my question because I don't want to post the same easy question if someone else has. But I just can't find the same problem.

I have created a sales file. In it I have four tables, customer info, sales, inventory, and a lineitems table. On the customer table, I have a portal that shows all records from the line items and I have a field on the customers table that is a calculation of "sum(line items:total)". So, on the sales sheet, we can enter in the customers tel. and then enter in what they bought. But what is happening is, if the tel. is entered in first, then anything bought before that isn't calculated on the cust table. It is acting like an autoenter function. How would I make it add all, past and present, to the customers total?

[Ender]

Sum(line items::amount) should work. Make sure the field is an unstored calculation.

If that's not it, maybe there's a problem with your relationships. Can you specify what your relationships and key fields are between these tables?

[Himitsu]

Ok... I was using two relationships that were conflicting with it. As for the past orders, I think it was strange that it wasn't calculating it before. Oh well, I got it to work. Ender, thanks for your time and response.