My goal is to have related TOs that can automatically "filter" the portals on the screen.
As of now, I have a layout based on a Client table with a portal listing all clients.
I am trying to filter the portal to display only the clients that attended today.
The tables are related as follows:
Client (Client ID) -> Attendance (Client ID)
If i would have an Attendance portal, it would display all the "attendances" today for that specific client, which is not what i want.
I would like to relate the tables (or TOs) in a way that it will filter out the clients that did not attend today.
Any ideas would be very much appreciated,