AnsweredAssumed Answered

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

Question asked by geo63 on Sep 29, 2016
Latest reply on Sep 30, 2016 by 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.

Outcomes