Junction Tables are an important tool when developing a database. This table represents the unique intersections of two other tables that already exist in your datasets. The purpose of the connection table is to create the ability to track these intersections at a detailed level.

This tutorial walks through the steps of building an intersection table and includes tips on how to run a published script to automatically create the unique intersections for your intersection! This will save you a lot of time and ensure that you always have all the records in your connection table!

_____________________________________________________

Read more via these links:

Come to our next live training!
https://www.garethpronovost.com/webinar-registration

Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-crash-course

Be stuck? See how we can help!
https://garethpronovost.com

Get our Airtable Field Type download!
https://www.gapconsulting.io/airtable-field-types

_____________________________________________________

Table of contents:

00:00 – What this video covers
00:39 – Explaining a connection table
02:14 – The /"wrong way/" to do it
03:32 – Building the node table
05:43 – Using an Airtable script to populate the intersection
10:02 – How to get more help!

_____________________________________________________

Software sources (may contain affiliate links):

Air Table – https://airtable.com/invite/r/v0eI3ASY

_____________________________________________________

#AutomateYourLife #GarethPronovost #Airtable

Please take the opportunity to connect and share this video with your friends and family if you find it helpful.