Get Nth record doesn't update

[knewt99]

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.

[John Mark Osborne]

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.

[xochi]

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?