AnsweredAssumed Answered

Trouble with distinct values in a portal.

Question asked by JeffTomb on Jun 8, 2016
Latest reply on Jun 8, 2016 by JeffTomb

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

Outcomes