AnsweredAssumed Answered

FM 13 Adv Summary field...

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

Title

FM 13 Adv Summary field...

Post

     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

     Accounts:

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

     Transactions:

     Date
     Check Number
     Check Amount
     Accounts::BudgetAmount
      

     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?

      

      

accounts.png

Outcomes