I am creating a database for our yoga business. To help us create great classes.
I have made some lists of yoga poses, pilates poses, other poses.
I also have a list for sequences (a selection of poses) and classes (a selection of sequences).
I have created some junction tables to allow many to many relationships.
A sequence could contain many poses and a pose could be used in many sequences. Likewise with classes. A sequence would be used in many classes and a class would contain many sequences.
I also have more details about the poses, sequences and classes in each list, such as level, duration, link to video etc.
So I want to create a form for Sequence whereby I create a sequence for example Cat Cow Sequence and then select the poses to add to that sequence. For this example it would be
Then when I have this sequence created I would want to create a class using a load of sequences but this example
Cat Cow Class
Obviously in reality it would be lots of different sequences.
When I create a form and sub form I can't select from predefined lists of poses just keep creating new ones and then I try and google for help and end up watching hours of videos and getting more lost.