Find records whose field's values are same
This would not be necessary in other query systems, but in FileMaker:
Define a calculation field in your table. Define it's calculation as:
job_no = site_no
select number as the result type.
Search for such records by entering find mode and specifying a 1 in this new calculation field.
how to define this ..I mean how to check this
If I create new field then how to set flag based on Job_no=site_no?
Flag? Do you mean how to use it in a find?
Enter find mode
Type a 1 in this calculation field
Perform the find
You can also use a scripted find.
No I mean in calculation field how to write it?
I try this
Is this write ?
I already posted that. It would be:
You're creating a boolean expression--one that evaluates to 1 (True) or 0 (False)
Retrieving data ...