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

    Trouble with distinct values in a portal.

    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