Find based on field value in a different table

[Joe Kuhn]

Table1::Field1 is a global field. It contains a value I'd like to use in a find with Table2::Field2.

I've tried the following as the Criterion in ScriptMaker:

Table1::Field1

==Table1::Field1

"Table1::Field1"

GetField("Table1::Field1")

==GetField("Table1::Field1")

None of these work. A literal does work. What am I missing?

Thanks.

Edited December 7, 2006 by Guest

[mr_vodka]

In your layout for Table2

Enter Find Mode []

Set Field [Table2::Field2; Table1::Field1]

Perform Find []

Globals fields values are global across the records in the table. You can perform a normal scripted find and just set the field to the related value that you want.

Also, with a cartesian 'X' join, you can have all the records in Table1 related to all the records in Table2.

Edited December 7, 2006 by Guest

[Joe Kuhn]

Thanks. That worked well and I added a few more Set Field calls.

Will be checking out that white paper.

I've worked in MS Sql for a long time and find FileMaker terms confusing. It's getting easier.

[Genx]

Lol,

And i find MS SQL terms confusing, but i'm slowly getting there :)