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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Computer101
EE Admin
ASKER