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: