Sounds like your flow should be like this:
- Shows an inline list of all lessons (assuming 25 lessons are 25 different rows).
- The action of the inline list item will be either show details view, then in the details view you show an inline list of assignments related to that lesson, or show new screen and point it to the relation of assignments.
Should work regardless of you using GSheets or Glide Tables to do it.