Using table relationships to show records in a database with matching fields

Posted on 2007-08-05
Medium Priority
Last Modified: 2010-04-27
For each product in my jewelry database, I would like to see (in a portal) what other products in the database share matching values.  The four fields I  would use to match are:

A) center stone type B) center stone cut C) style D) Material

The portal should show a list of all matching products based on the fields above, with a number representing  how many of the four fields each product matches on.

I have created a relationship to match each of the 4 fields above.  How do I create a portal that will show every product that matches the current record being viewed, and how many fields it matches on (from the four table relationships already created)

You can view the database here:

Question by:jarrodprice
  • 2

Author Comment

ID: 19665079
No takers?

Accepted Solution

JoJohn2004 earned 2000 total points
ID: 19667189
The structure of your database does not lend itself easily to this task. I have posted a possible solution using a technique that I just learned at DevCon so it may not be too elegant. You can find it at:


This example does not limit the number of details that are matched. It will match and count all the details for that item. The concept is that you create a multi-Key for an item in a global that is made up of the details in the related records. This is where you would filter out the detail you do not want. Once that Key is made you can obtain a related set and the resulting list is sorted. A looping script is used to count how many times a particular Item shows up in the list. That will be the number of matches. This info is then placed in a global repeating field and is displayed in a tabular format.

I tried repeatedly to do this with just relationships and my brains just sort of short circuited every tiime.

Author Comment

ID: 19667252
I appreciate the effort!  I have had no luck doing it with relationships either.  I will take a long look at your sample, to figure out if it will work for me.

Expert Comment

ID: 20120415
Forced accept.

EE Admin

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Integration Management Part 2
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question