Aug 20 2019 12:19 AM
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
Cat Pose
Cow Pose
Then when I have this sequence created I would want to create a class using a load of sequences but this example
Class
Cat Cow Class
Sequences
Cat Cow
Cat Cow
Cat Cow
Cat Cow
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.
Help appreciated.
Namaste.
Chris
Aug 20 2019 07:47 AM
This tutorial https://youtu.be/Ou1zwJunbuA was helpful but still not working for me.
Problem is when he is creating the query for subform he has things linked to a customer form at top.
I am just trying to do something that should be simple.
Create a sequence and add into that sequence a load of yoga poses using a combo box.
Once I have done this I guess I can repeat the logic to create a classes form and then use a combo box to add a load of sequences to a class.
Feels like I am wasting hours on something that must be so simple.
Thanks in advance.
Chris