AnsweredAssumed Answered

Total NOT based on global needed.

Question asked by synergy46 on Feb 8, 2011
Latest reply on Feb 9, 2011 by synergy46

Title

Total NOT based on global needed.

Post

I have a Membershiip database.

One table is "Setup" which has these global fields:
       Dues
       Assessments
       Other

Into these fields are the 'current' amounts that compose the Total Dues.

Another table is Dues with these fields:
        DuesAmt
        AssessmentAmt
        OtherAmt
        ExpectedAmt

The Dues::ExpectedAmt field is the total of the global fields: Setup::Dues + Setup::Assessmeents + Setup::Other

This works great... until I change the Setup::Dues , Assessments or Other fields.  Then, all the records in the portal also change accordingly.

This means that if I enter 25 15 5 for Setup global fields  in  2009 (total 40) that is what shows in the Dues::ExpectedAmt field in the  portal row for 2009

If there is a 2010 dues increase to say .... 30 15 5, then the 2009 and 2010 ExpecctedAmt shows the new value 50.

Seems like I read an invoicing address problem that was similar to this but I can't get the details to come back.

Any ideas?  What's the trick?

(Setup Table shown below)

ishot-463.jpg

Outcomes