Jump to content

Search Related Database


beckham
 Share

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

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

 

  • Like 1
Link to comment
Share on other sites

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. 

  • Like 1
Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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