May 30, 201114 yr Update: Got it to work. The problem was in my script that calculates the meter values. I have a water meter billing application. (It is for a non-profit LID so there is no money for custom programming) There are 2 tables: Property PK_Property BillingAddress Address etc,,, MeterReadings FK_PropID PK_MeterID ReadDate MeterReading Property is one:many with MeterReadings Looking at the METERREADING layout shows the situation. My problem is, for some reason, (perhaps this is where you can weigh in), the DIFFERENCE field only has the current calculation between the current reading and the prior reading. And to make it even more weird, if a new reading is made, the DIFFERENCE calculation is correct but it again shows at the bottom row of the portal (It should be at the top corresponding to the date of entry) (Difference is scripted). Question: "Why doesn't the value 'plugged into DIFFERENCE' get added as part of the new record? Thanks for reading... HVEWater1.fp7.zip
Create an account or sign in to comment