What am I doing wrong?

I want to compare the value in an Address field to the value in the same Address field in the previous record.

I've created a calc field-

GetNthRecord(Address;Get(RecordNumber) - 1)

This works at first, but if I change the Address in the first record, the calculation in the next record does not update until I click in it.

I've tried both storing the calc results and not storing but it seems to make no difference.

Any ideas? Thanks.

It works for me with the following unstored calculation field:

GetNthRecord(Address; Get(RecordNumber) - 1) = Address

It reutrns a 1 if they are the same and a 0 when they are different. It updates when I change record 1 and move to record 2 without clicking into the field.

BTW, you might want to update your profile to show that you are using FileMaker 8.

It's important to figure out whether the field didn't update at all, or if simply the screen display didn't update.

If it's the latter, you can force it to update by a "Refresh window/flush cached joins" script step.

If it's the former, you may need to "trigger" the update by setting another field, "TriggerField" in the same record, something like:

Let(

dummyFieldToUPdateThis = TriggerField;

GetNthRecord(Address;Get(RecordNumber)-1)

)

Then you just have a script step which sets TriggerField to any value.

Though, I suspect your problem is probably a display problem, not an actual update problem?