Home

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
ChrisDownham
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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies