employee attendance record

[dbfreak]

Hello all! I hope everyone is looking forward to a pleasant holiday.

I'm wondering if Im thinking about this properly.

I have set up the following tables: event, employee, employee attendance.

The event table is the "master table" I would like to have a portal that displays "active employees that are paid on a daily rate"

That should come from the Employee table and the filtering I have set up works properly.

I then would like to make new records in "employee attendance". It would be great if I could do so with the found set of the above filtered

portal so I wouldn't have to manually select every employee on a daily basis.

I have tried a few different ways but what I have in my mind isn't working. It leads me into trying to make 2 portals working together or within each other and that isn't possible.

I hope this makes sense.