TrackVia University On-Demand: Many-to-many Relationships Course

In addition to the detailed written articles found in this knowledge base, TrackVia University offers a hands-on learning experience through a series of on-demand video courses. Below is an overview of the Many-to-many Relationships course, which can be found HERE.

 

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