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:
>>> #2 Transactions
SumBudget = Summary(Budget)
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?