I am working on an estimating database that includes the basic tables and standard table relationships (described below). In the Product table I have a field indicating the vendor who provides the product. I capture the vendor when I create a record in the Estimate Line Items table. From the context of ESTIMATE, I would like to display in a portal a the unique vendors who's products are quoted. I know there is a way to do it, but haven't had any luck.
I have three related tables:
ESTIMATES ESTIMATE LINE ITEMS PRODUCTS
_idEstimate = _idestimate
_idproduct = _idproduct