I want to take advantage of something that is already in one table to duplicate it in another

I’m developing a gym app, where the teacher responsible for the student will designate the student’s training and on another screen the student will be able to enter their personal development according to the load they took.

I would like to know how I can do it so that the student can record this load daily and in the end I can add it up.

I have a table called “Workouts” which is where the Exercise ID is placed, the Video of how it is done, the series and also repetitions. Furthermore, in the “Daily Training” table, I would like to maintain the layout and apply the LOAD column, as follows: