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, 200619 yr by Guest

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

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.

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