searchstring 'table::field' won't work, why?

[glzm0]

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 :

[inovermyhead]

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.

[Ender]

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[].