Get value from field and search in another field

[GarrettC]

I am stumped on this...

I am attempting to create a script that will get the contents of one field on the current record and use that value to search for the existence of that value in another field across the whole table. The final stage, I need to put the value I searched for in yet another field as part of a report of what took place.

I have attempted several different methods but I am having trouble passing and holding values between the combinations of scripts and functions that I have put together.

My last attempt was to go into Find mode...

Use an Insert Calculated Result to put the field of choice.

Depending on how set the Find, I had different failures...

I am not even sure how I would retain the value of the Find and put that in another field.

If someone could guide me on the correct steps of the process I will figure out the rest.

Thanks so much for any help.

[mr_vodka]

Set Variable [ $temp; YourField ]

Enter Find Mode []

Set Field [ Field1; $temp ]

New Record / Request

Set Field [ Field2; $temp ]

Perform Find []

This will find the value in all the records for both fields.

[GarrettC]

Mr Vodka, thanks for your reply.

But there is a bit of a problem....

I at first could not create the script at all in version 7 of Filemaker, which it must be in at this time, there is no Set Variable script step there.

So I opened my copy of Filemaker 8 Advance and created the script you showed me, with small variations it worked like a charm. I have been able to do a bunch of work in this manner and then go back to version 7 non-advanced.

It looks like Set Variable script step is not available in version 7. Now a question or two...

Is there a way to do the same thing version 7, in another manner?

Is the Set Variable script step available only in version 8 or only in 8 advanced? Both?

[GarrettC]

Thought I would post the script for other's delight and illumination...

Freeze Window

Set Variable [ $KeyVar; Value:JIRA_ALL::KEY ]

Enter Find Mode [ ]

Set Field [ JIRA_ALL::Issue Links; $KeyVar ]

Perform Find [ ]

Set Field [ JIRA_ALL::FOUND SET; $KeyVar & " – Key Links – " & Get ( FoundCount ) ]

Sort Records [ Specified Sort Order: JIRA_ALL::KEY; ascending ] [ Restore; No dialog ]

Set Field [ JIRA_ALL::SORT STATUS; "Issue Key" ]

Show/Hide Status Area [ Hide ]

Show/Hide Text Ruler [ Hide ]

Refresh Window

[mr_vodka]

My apologies for not noticing your version earlier. In FM7 you can use a global field instead of the variable. Just replace all instances of the variable with the global field.