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.