Hello! I am struggling for many days with this one. We are building an library app for schools where teachers have access to list of PE lessons plan.
WHAT I NEED tl;dr
I need to connect info about exercises from 3 databases and then show them in 3 different repeaters which is behind another repeater (dynamic page).
EXPLANATION
There are 5 classes options, each class consists of 40 lessons. All content is preset - we have existing databases of these presets. To prevent making 200 pages we use Dynamic pages for this.
There is a tricky part though. Each lesson consists of 3 parts (starter,main,finnisher) which are also variable. Each part has own database aka list of exercises (about 50 for each part). I used repeater for each part.
How do I fill each part with proper exercises? I created database for 1. Class where I have 40 lessons. I define each lesson with multirefence field that should get info about exercise from their own databases. My question is, is this the way? Do you guys have some other idea how to do this? Do I need some custom code?
I am willing to explain my issue further if needed.
Thanks a lot for any idea.
Tom