Calculation Field Across Multiple Records

[adyf]

Looking at the below image, is it possible to create a calculation field that will look at Paths from: and Paths to: fields and if they are identical as in the below three records, put the contents of the name field into the calculation field? Therefore the new calculation field would contain 'Crookes Blakemore Fairburn' across all three records.

I could create a script to do this, but would be happier if I could achieve the same result with a calculation field. Unfortunately I only have Filemaker 6. Be delighted if someone could help.

Edited July 2, 2009 by Guest