I've got a database with fields A, B, C, D, E…

Some records have the same value in A and B.

I'd like to find all these records (and then copy these values into C.)

Can I obtain this with a (more or less) simple find, like 'find all records with (value)A = (value)B)'?

If not, is there another approach?

Thanks for help

Jurgen

Filemaker does not perform calculations during find, so in order to find records where A = B, you must either add a calculation field (result is Number) =

A = B

and search for 1 in this field, or show all records and loop among them, omitting each record that does not meet the criteria.

This part is not quite clear. Prhaps all you need to do is make C a calculation field =

Case ( A = B ; A )

This way you don't need to find anything, it's already done.