in FM 11 I'm having a hard time figuring out how to show all records which field1 and field2 contain the same value. (field2 = field1)
How do I do this?
You can create a calculation field such as:
If ( field1 = field2 ; 1 ; 0 )
Then you can search this new calculation field for whenever the new calcuation field equals 1.
You could also do this with a looping script and avoid the calcuation field. But the calcuation field is an easy way to go.
You just made my day - thanks so much, works perfect.
Retrieving data ...