June 29, 200718 yr I do have a script which should perform a search. I used the command 'Constrain Found Set [Restore]' the criteria is 'Field_1="Hello"' Cool this works , every record which value in Field_1 is Hello is shown. Now I thought to put the searchvalue "Hello" into a global field in another Table which is referenced to my searchtable. Then I used again the command "Constrain Found Set [Restore]" the criteria this time is 'Field_1=Table_reference::Field_search_value' . But this time the script, or better the search, stopped and told me that the value 'Field_search_value' couldn't be found. OK - ounds logical. What do I have to write that the criteria takes the CONTENT of the referenced field? Is there a way or is this like the same with variables, which FM isn't able to use in searchstrings? sorry again for my bad english =) correct it if you would, this helps me for the next time :
June 29, 200718 yr Newbies This may not be the most eligant solution to your problem, but I was having the same issue and this is what I managed to get working. Enter Find Mode [] Set Field[Field1;g_Field1] Perform Find [] It's crude, but it worked me.
June 29, 200718 yr Ya, you can't use source fields (or variables) in the Restored options for a Find. You have to set the Find criteria explicitly with a Set Field[].
Create an account or sign in to comment