Spotting The Difference

[Rob Halliday]

Hello All,

Is there any way of using a calculation to 'spot the difference' between a field in one record and the same field in the previous record?

I have a database where many records contain the same value in one field. I'm trying to highlight the row where that value changes. Effectively I want a field that can calculate itself as 'if field x this record not equal to field x in previous record, set something'.... but I can't figure out any way to do that as a calculation.

Any ideas gratefully received!

Thanks,

Rob.

Edited March 4, 2006 by Guest

[Wim Decorte]

Can you do it through a script (maybe as part of the scripted navigation going to a particular layout)? It will save you from some performance degradation by having an unstored calculated field in a list view.

There was a technique in 6 to do this with a calc IIRC. Check databasepros.com

[Rob Halliday]

Hi,

Yes, I can do it with a script....

But a calculation would mean that it could happen 'automatically' every time a list view is generated, rather than having to generate the list then run the script over that list.

Rob.

[Reed]

what about moving to the current version of FMP, and using the GetNthRecord() function?