Hi Guys can anyone offer insight to how i can search a related record with the following example.

I have 2 Filemaker databases that are related via the ID.

1 database as a field containing data" WA1234", my other database as a field containing data "1234".

How can I find this second record exists without opening that 2nd database and searching ? note the WA doesn't exist in the second database.

Thanks for any pointers.

That's actually quite an astonishing level of minimalism and vagueness.

But you could go even further in that direction.

Just say, well I have two databases. And I want something.

1 hour ago, beckham said:

1 database as a field containing data" WA1234", my other database as a field containing data "1234".

How can I find this second record exists without opening that 2nd database and searching ?

If you define a calculation field in the first file that takes "WA1234" as its input and calculates "1234" as the result, you can then use this as the matchfield in a relationship to the other file.

I can't tell from a single example what that calculation should be - perhaps Right ( Yourfield ; 4 ) would do.

Note also that "finding" by relationship will open the other file.

 

You could add the search field of the  related table on its own layout on the first file and search only there if not opening the second file the the key parameter. 

3 hours ago, Aussie John said:

You could add the search field of the  related table on its own layout on the first file and search only there if not opening the second file the the key parameter. 

I for one have no idea what you mean by that (it's not even a proper sentence).