Jump to content

Finding in 2 files with 1 find


Eliz309
 Share

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

Recommended Posts

I would like to be able to enter find criteria for 1 specific field and have filemaker search the main file and the related file. I was trying to re-write my find script, and i inserted

If [lastname = "Jones"}

Enter Find Mode

Insert Text [Related;;Lastname, "Jones"

[select entire contents]

Perform Find

[Extend Found Set]

But that is not working. Can someone help?

Thanks

Link to comment
Share on other sites

hi eliz309

Make a global field (ie. S_global)in the second db. Use the set field command to get the criteria from the search field(f_global) to S_global field and write a find script in the second db and activiate it from the first. Make sure you have a relationship between the two db's

example: this script is where you start the search from

set field(S_global,f_global)

enter find mode

insert calculated results("lastname"."f_global)

perform find

write another script in the second db similar to this one and activiate it with the "perform exteranl script ciommand".

i hope this was clear enough to understand.

lionel

Link to comment
Share on other sites

This topic is 6569 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.