2 Replies Latest reply on Jun 8, 2016 1:08 PM by JeffTomb

    Trouble with distinct values in a portal.


      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