Keeping select matches based on a condition

[#1]

In the attached example, I'm able to highlight the product for a given BUYER when matched to a given SELLER.

For the selected BUYER, I want to serve up those SELLERS who carry CORN and APPLES since these are the BUYER's most important products.   I've tried different approaches but no luck.

I want to keep it simple by somehow "selecting" those products in the BUYERS list and then only have Sellers appear that meet the condition.

thanks

[Anonymous]

Rick,

If you rename Buyer Product and Seller Product to the same name (e.g. Product), the tables in your app will be linked, and you get the desired result with no additional efforts.