Total NOT based on global needed.
I have a Membershiip database.
One table is "Setup" which has these global fields:
Into these fields are the 'current' amounts that compose the Total Dues.
Another table is Dues with these fields:
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)