Hi everyone,

I'm hitting a brick wall here, and would like some help if possible.

I have one fp7 file with two tables. Each table has a userID field, which have an established relationship. This seems to work fine.

I need a script that will do the following. When switching from a layout on table 1, will perform a find and only display records on table 2 with a matching userID.

Currently, I have the following script:

Enter Find Mode []

Set Field [table2::UserID; table1:UserID]

Perform Find[]

Go to Layout [table2] //don't remember the exact syntax I used, but I know this part works

This script errors out at Perform Find. It says that an invalid search criteria has been entered and that I need to input it manually.

Thanks for all your help

Hi everyone,

I'm hitting a brick wall here, and would like some help if possible.

I have one fp7 file with two tables. Each table has a userID field, which have an established relationship. This seems to work fine.

I need a script that will do the following. When switching from a layout on table 1, will perform a find and only display records on table 2 with a matching userID.

Currently, I have the following script:

Enter Find Mode []

Set Field [table2::UserID; table1:UserID]

Perform Find[]

Go to Layout [table2] //don't remember the exact syntax I used, but I know this part works

This script errors out at Perform Find. It says that an invalid search criteria has been entered and that I need to input it manually.

Thanks for all your help

Hi everyone,

I'm hitting a brick wall here, and would like some help if possible.

I have one fp7 file with two tables. Each table has a userID field, which have an established relationship. This seems to work fine.

I need a script that will do the following. When switching from a layout on table 1, will perform a find and only display records on table 2 with a matching userID.

Currently, I have the following script:

Enter Find Mode []

Set Field [table2::UserID; table1:UserID]

Perform Find[]

Go to Layout [table2] //don't remember the exact syntax I used, but I know this part works

This script errors out at Perform Find. It says that an invalid search criteria has been entered and that I need to input it manually.

Thanks for all your help

When you enter Find mode, no UserID is there to match on since find mode does not provide data. You can have a global field set with the UserID and then in find mode set the UserID to the global variable and your find criteria will no longer be empty.

When you enter Find mode, no UserID is there to match on since find mode does not provide data. You can have a global field set with the UserID and then in find mode set the UserID to the global variable and your find criteria will no longer be empty.

When you enter Find mode, no UserID is there to match on since find mode does not provide data. You can have a global field set with the UserID and then in find mode set the UserID to the global variable and your find criteria will no longer be empty.

Okay so here is what I did:

Made a global field called scratch1 in table 1.

made a script to do the following:

Set Field [table1::scratch1; table1::UserID]

Enter Find Mode []

Set Field [table2::UserID; table1:scratch1]

Perform Find[]

Go to Layout [table2]

Result: Doesn't error out but displays all data now in the layout for table2.

Okay so here is what I did:

Made a global field called scratch1 in table 1.

made a script to do the following:

Set Field [table1::scratch1; table1::UserID]

Enter Find Mode []

Set Field [table2::UserID; table1:scratch1]

Perform Find[]

Go to Layout [table2]

Result: Doesn't error out but displays all data now in the layout for table2.

Okay so here is what I did:

Made a global field called scratch1 in table 1.

made a script to do the following:

Set Field [table1::scratch1; table1::UserID]

Enter Find Mode []

Set Field [table2::UserID; table1:scratch1]

Perform Find[]

Go to Layout [table2]

Result: Doesn't error out but displays all data now in the layout for table2.

You're performing a find in table1, not in table2, for records where table2::UserID = table1::UserID. There is no connection between the resultant found set in table1 and the found set in table2.

You either need to perform your find in table2 or simply create a relationship from table1::UserID to table2::UserID and use Go to Related Records [show only related; "yourRelationship"] instead of setting a global and performing a find.

You're performing a find in table1, not in table2, for records where table2::UserID = table1::UserID. There is no connection between the resultant found set in table1 and the found set in table2.

You either need to perform your find in table2 or simply create a relationship from table1::UserID to table2::UserID and use Go to Related Records [show only related; "yourRelationship"] instead of setting a global and performing a find.

You're performing a find in table1, not in table2, for records where table2::UserID = table1::UserID. There is no connection between the resultant found set in table1 and the found set in table2.

You either need to perform your find in table2 or simply create a relationship from table1::UserID to table2::UserID and use Go to Related Records [show only related; "yourRelationship"] instead of setting a global and performing a find.