I have a very simple portal for transactions - a receipt field and a payments out field.

Then a "diff" field isswimply Receipts - Payments

The balance is given by a summary field using runnung total of "diff"

The problem is that the balance will only update when I manually click into the Bal Field and then only for that record

I must me appraoching this from the wrong angle but any help would be VERY much appreciated

Yjanks

Can you post a sample? I have a very similar file (see here) and it refreshes instantly - except when a key field is changed. That can be scripted, and a Refresh Window script step takes care of the problem.

except when a key field is changed

...or a non equijoin I beleive!!

--sd