Display calculated Totals in Form

Discussion of the version of HanDBase that runs on the iPhone and iPod touch devices. This includes the synchronization conduits as well.

Display calculated Totals in Form

Postby maxwuchtig » Wed Mar 20, 2013 10:37 am

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 !
maxwuchtig
 
Posts: 2
Joined: Wed Mar 20, 2013 10:22 am

Re: Display calculated Totals in Form

Postby dhaupert » Wed Mar 20, 2013 3:32 pm

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.
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am

Re: Display calculated Totals in Form

Postby maxwuchtig » Thu Mar 21, 2013 3:41 am

Thanks for your quick help !
maxwuchtig
 
Posts: 2
Joined: Wed Mar 20, 2013 10:22 am


Return to HanDBase for iPhone and iPod touch

Who is online

Users browsing this forum: No registered users and 1 guest