AnsweredAssumed Answered

Unique List in Related Portal

Question asked by r.s. on Nov 13, 2018
Latest reply on Nov 13, 2018 by comment

Table 1: Clients

Table 2: Attendance


These two tables are related through a cartesian join. ( Client Id )


My question is like this: I want to display a list of all the clients that attended today. I have a layout that is based on the Clients table, and a portal that is based on the Attendance table, filtered to display the clients that attended today. The user can sign in and sign out, and then sign in again. This causes the user's name to appear twice (or as many times as he signs in) in the attendance portal.


I would like to have a portal that only shows the unique client list of the clients attended.


Any ideas?