Finding in 2 files with 1 find

[Eliz309]

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

[oilman]

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