8 Replies Latest reply on Sep 30, 2016 1:45 PM by geo63

    How to display all found records in a single portal when there are multiple parents

    geo63

      I have an application where I am trying to view all applicants that an approver has been assigned.

      Any business can setup multiple approvers.

      Any applicant can apply to any company.

       

      Approvers Table

      -----------------------

      BusinessID

      ApproverID

       

      Approvals Table (portal)

      ----------------------

      ApplicantID

      BusinessID

       

      the portal will display any applicants requesting approval provided that the current Approver has been assigned for that business.

       

      Scenarios:

      1.  Approver1 logs in as an approver for Business1

           The portal would list any applicants for Business1 to be approved.

      2.  Approver2 logs in as an approver for Business2

           The portal would list any applicants for Business1 to be approved.

      ...etc

       

      The problem comes in when Approver1 is listed as an approver for Business1 and Business2.

      The portal will display the information, however, I have to use the next record button to see the Business2 data.

      I would like all applicants to appear in a single portal without having to scroll to the next record.