You already have a list of the desired students as related records in PE Assignments table. You could ...
- find those records (eg Go to Related Record, matching only)
- export them (basically all you need to export is the studentID and the classID)
- go to the PE1 Attendance table
- import the previously created export file into PE1 Attendance
- batch-set the date
I have many tables all connected through student id.
Well, they cannot be all connected by classID; what about PE and PE Assignments ...