Field in portal not working

[ron G]

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