find based on comparison of fields?

[GlennC]

I need to do a find based on two numeric fields being the same. The value itself will not be constant. In other words the search criteria is that the two fields are the same, regardless of the value in the fields.

I am clueless at the moment - only a couple of days into FM (Pro 6) and I can't seem to get to first base with this. Once it gets worked out I then need to save that search somehow - I'm surprised that there doesn't seem to be some straight-forward way of saving queries (finds) - but I'm sure that's just my lack of conceptual understanding at the moment.

Very gratefull for help.

Glenn

[djgogi]

You don't need "find" just an other field let's call it "eqField"defined as field1=field2 result number and an global number field gEq with value 1 in it.

Now define an relationship gEq-->eqField and use the Go to Related Record script step with option show only related records enabled.

However, since eqField has to be indexed instead of relationship you could also use Find for value 1 in eqField

Dj

[jasonwood]

or you could just have a field that calculates the difference (field1 - field2), and do a search for difference = 0

[GlennC]

Yes, OK. thanks to you both.