Jump to content

Find based on field value in a different table


Joe Kuhn
 Share

This topic is 5773 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 by Guest
Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5773 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.