PhilModJunk has a file you might want to take a look at.
It has a field where you can begin typing, and while you type a portal updates and show values that are equal to the text you are typing.
I happen to have it on my computer.
Again, no credit for me, This is not my file.
Oo thanks I'll take a look at that! I solved it myself though, by using a variable in the script which holds the value of the first layout and then uses it for a search in the second. Still, I love taking a peek at other methods - they may come in handy for another time!
Now I understand where your problem was.
Because you wrote in your original post:
- set the field I want to filter with the unique field
I already saw a
- Set Variable
- Set field
in my head.
Glad you solved it.
Haha well some things are so obvious when you understand how Filemaker works - I figured that it would just go get the right value but it doesn't.
Still, I only started using the program on friday and I already got a nice database set up and it's been 10 years since I went to uni and was taught database relationships so I don't think I'm doing too poorly ;) I'm sure I'll be learning more tricks which will make me redo a lot of stuff but for now, it's far better than the solution they had at work before.
The set variable, set field method should work. Your script will look like this:
Set variable [$Value ; value: YourTable::YourField]
Go to Layout [//select second layout]
Enter Find mode  // clear the pause check box
Set field [YourOtherTable::YourField ; $value ]
Set Error Capture [on] // keeps "not found dialog from interrupting your script if no records are found
Perform Find 
And you can include code after the Perform Find step that either checks for an error code or that uses get ( foundCount ) to count the records found to handle cases where no records were found.