Link to home
Start Free TrialLog in
Avatar of jarrodprice
jarrodprice

asked on

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

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:

http://www.diagiodiamonds.com/ebay/Database.rar
Avatar of jarrodprice
jarrodprice

ASKER

No takers?
ASKER CERTIFIED SOLUTION
Avatar of JoJohn2004
JoJohn2004

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Forced accept.

Computer101
EE Admin