AnsweredAssumed Answered

FM 13 Adv Summary field...

Question asked by synergy46 on Jul 12, 2014
Latest reply on Jul 13, 2014 by synergy46


FM 13 Adv Summary field...


     Surely there is an easy way to do this; I just can't think of it... grrr

     I have two tables:

             #1 Accounts
     >>> #2 Transactions


      Account Number
     Account Description
     Budget Amount
SumBudget = Summary(Budget)


     Check Number
     Check Amount

     Everything works.  But, I can put SumBudget in the header of my Accounts total and it shows the sum.  Good.


     I put the same SumBudget field on my Transactions layout and it does NOT show the Accounts Budget summary.  Instead it shows the total for a single Transaction budget line.   (I am in LIST view).

     It doesn't make any difference if I make Accounts::SumBudget global or I change it from a summary field to a calculated field with a sum(Accounts::Budget) which is or is not global.... Nothing seems to let me put Accounts::SumBudget on Transactions.

     I can probably script something that will 'carry' Accounts::SumBudet to a field in Transactions::SumBudget but that seems like a hassle.  

     Is there a simple, "Filemaker" way to do this without having to script it?