Knowledge Base Developer Docs
Course 13 - Many-to-Many Relationships

Course 13 - Many-to-Many Relationships

Learn what many-to-many relationships are and various ways to achieve them within your account.

rate limit

Code not recognized.

About this course

The most common type of relationship between two tables in TrackVia is a one-to-many relationship. However, there are many circumstances where this type of relationship won't meet the needs of your application. This course will teach you how to recognize when a many-to-many relationship is necessary and the various ways to achieve them within your table structure. 

Learning Objectives

  1. Defining many-to-many relationships
  2. Examples of many-to-many relationships
  3. Setting up many-to-many relationships with multiple table relationships
  4. Setting up many-to-many relationships with join tables
  5. Pros and cons of multiple relationships and join tables

Recommended Prerequisites

All Orientation courses and Core Functionality courses

Curriculum49 min

  • Getting Set Up
  • Before You Begin! 2 min
  • Step 1: App Prep 5 min
  • Step 2: Course Prep 10 min
  • Course Material
  • Defining Many-to-Many Relationships 4 min
  • Knowledge Check 1 min
  • Creating Many-to-Many Relationships with Multiple Table Relationships 6 min
  • Knowledge Check 1 min
  • Creating Many-to-Many Relationships with "Join Tables" 15 min
  • Knowledge Check 1 min
  • Key Takeaways 3 min
  • Course Feedback 1 min
  • Next Steps

About this course

The most common type of relationship between two tables in TrackVia is a one-to-many relationship. However, there are many circumstances where this type of relationship won't meet the needs of your application. This course will teach you how to recognize when a many-to-many relationship is necessary and the various ways to achieve them within your table structure. 

Learning Objectives

  1. Defining many-to-many relationships
  2. Examples of many-to-many relationships
  3. Setting up many-to-many relationships with multiple table relationships
  4. Setting up many-to-many relationships with join tables
  5. Pros and cons of multiple relationships and join tables

Recommended Prerequisites

All Orientation courses and Core Functionality courses

Curriculum49 min

  • Getting Set Up
  • Before You Begin! 2 min
  • Step 1: App Prep 5 min
  • Step 2: Course Prep 10 min
  • Course Material
  • Defining Many-to-Many Relationships 4 min
  • Knowledge Check 1 min
  • Creating Many-to-Many Relationships with Multiple Table Relationships 6 min
  • Knowledge Check 1 min
  • Creating Many-to-Many Relationships with "Join Tables" 15 min
  • Knowledge Check 1 min
  • Key Takeaways 3 min
  • Course Feedback 1 min
  • Next Steps