Database to create yoga and pilates classes from lists of sequences and poses

%3CLINGO-SUB%20id%3D%22lingo-sub-812251%22%20slang%3D%22en-US%22%3EDatabase%20to%20create%20yoga%20and%20pilates%20classes%20from%20lists%20of%20sequences%20and%20poses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-812251%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%3CP%3EI%20am%20creating%20a%20database%20for%20our%20yoga%20business.%26nbsp%3B%3CSPAN%3ETo%20help%20us%20create%20great%20classes.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%3CP%3EI%20have%20made%20some%20lists%20of%20yoga%20poses%2C%20pilates%20poses%2C%20other%20poses.%3C%2FP%3E%3CP%3EI%20also%20have%20a%20list%20for%20sequences%20(a%20selection%20of%20poses)%20and%20classes%20(a%20selection%20of%20sequences).%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%3CP%3EI%20have%20created%20some%20junction%20tables%20to%20allow%20many%20to%20many%20relationships.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20sequence%20could%20contain%20many%20poses%20and%20a%20pose%20could%20be%20used%20in%20many%20sequences.%26nbsp%3B%20Likewise%20with%20classes.%26nbsp%3B%20A%20sequence%20would%20be%20used%20in%20many%20classes%20and%20a%20class%20would%20contain%20many%20sequences.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20have%20more%20details%20about%20the%20poses%2C%20sequences%20and%20classes%20in%20each%20list%2C%20such%20as%20level%2C%20duration%2C%20link%20to%20video%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20want%20to%20create%20a%20form%20for%20Sequence%20whereby%20I%20create%20a%20sequence%20for%20example%20Cat%20Cow%20Sequence%20and%20then%20select%20the%20poses%20to%20add%20to%20that%20sequence.%26nbsp%3B%20For%20this%20example%20it%20would%20be%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECat%20Pose%3C%2FP%3E%3CP%3ECow%20Pose%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20when%20I%20have%20this%20sequence%20created%20I%20would%20want%20to%20create%20a%20class%20using%20a%20load%20of%20sequences%20but%20this%20example%3C%2FP%3E%3CP%3EClass%3C%2FP%3E%3CP%3ECat%20Cow%20Class%3C%2FP%3E%3CP%3ESequences%3C%2FP%3E%3CP%3ECat%20Cow%3C%2FP%3E%3CP%3ECat%20Cow%3C%2FP%3E%3CP%3ECat%20Cow%3C%2FP%3E%3CP%3ECat%20Cow%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EObviously%20in%20reality%20it%20would%20be%20lots%20of%20different%20sequences.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20create%20a%20form%20and%20sub%20form%20I%20can't%20select%20from%20predefined%20lists%20of%20poses%20just%20keep%20creating%20new%20ones%20and%20then%20I%20try%20and%20google%20for%20help%20and%20end%20up%20watching%20hours%20of%20videos%20and%20getting%20more%20lost.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENamaste.%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-812251%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-812925%22%20slang%3D%22en-US%22%3ERe%3A%20Database%20to%20create%20yoga%20and%20pilates%20classes%20from%20lists%20of%20sequences%20and%20poses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-812925%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20tutorial%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FOu1zwJunbuA%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FOu1zwJunbuA%3C%2FA%3Ewas%20helpful%20but%20still%20not%20working%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20is%20when%20he%20is%20creating%20the%20query%20for%20subform%20he%20has%20things%20linked%20to%20a%20customer%20form%20at%20top.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20just%20trying%20to%20do%20something%20that%20should%20be%20simple.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20a%20sequence%20and%20add%20into%20that%20sequence%20a%20load%20of%20yoga%20poses%20using%20a%20combo%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20I%20have%20done%20this%20I%20guess%20I%20can%20repeat%20the%20logic%20to%20create%20a%20classes%20form%20and%20then%20use%20a%20combo%20box%20to%20add%20a%20load%20of%20sequences%20to%20a%20class.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFeels%20like%20I%20am%20wasting%20hours%20on%20something%20that%20must%20be%20so%20simple.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

1 Reply
Highlighted

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

Creating a subform in a main form becomes more tricky when the subform is based on tables that have a many-to-many-relationship.