Jump to content
Sign in to follow this  

Find Recordes when criteria is: field1=field2

Recommended Posts

I am writing a find script, in which I would like to specify the find request

that Finds Records where table1::field1 = table1::field2

field2 is a global variable which I am using only to specify the values of field1 that I want to find. When I enter field2 into the find criteria, it trys to find values of field1 that = "field2", rather than the global value that field2 is set to. Does that make sense? How can I work around this?

Any help would be greatly appreciated!


Share this post

Link to post
Share on other sites

Hi chirt1, and welcome to FM Forums!

If this is a script, use table1::field2 without quotes in your Set Field statement. The quotes signify literal text.


Share this post

Link to post
Share on other sites

I will assume you are referring to specifying requests in either the Enter Find Mode or Perform Find step. Such requests can only be specified when their data is static, i.e., when you always want to find the same thing. For dynamic requests, you don't specify requests, but instead use Set Field as in

Enter Find Mode [ ]

Set Field [table1::field1; table1::field2]

Perform Find [ ]

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.