Page 1 of 1

Display calculated Totals in Form

PostPosted: Wed Mar 20, 2013 10:37 am
by maxwuchtig
Hi there,

i have 2 tables, "Customers" and "Orders".
I want to see the amount of the field "price" from all records of the selected customer from table "Orders" in the List View of "Customers".
So i created a new calculated field in "Orders" named "Sum" with formula PREV Sum + price.
That works so far, so i get the total amount of price for a specific customer at his last record.
Now my goal is to get this value of the field "Sum" in the List View of "Customers".
Therefore i created a new field named "relSum" in table "Customers":

type: "Relationship"
related field in this database: "CustomerName"
other Database: "Orders"
field in other database: "CustomerName"
show from other database: "Sum"
from which record: "last matching record"

That does'nt work :-(
In "Customers" List View there is the new Column "relSum", but there is no value shown.

Please help me !

Re: Display calculated Totals in Form

PostPosted: Wed Mar 20, 2013 3:32 pm
by dhaupert
This should definitely work- I use this all the time in my databases! Perhaps you can send me a copy of both tables so that I can see where things may be going wrong? My email is listed below.

Re: Display calculated Totals in Form

PostPosted: Thu Mar 21, 2013 3:41 am
by maxwuchtig
Thanks for your quick help !