Can someone explain what a “join table” is, how it works, and any benefit to using it?

[MikesClub]

I’ve seen a few references to this here on the forum, but it doesn’t seem to be an actual defined Adalo term.

It seems to be a way to emulate a many to many relationship without actually using that type of relationship.

How and when should I use it?

What are the pros and cons?

Please lay out an example if possible.

Thank you all so much!

[Dilon]

Hi Michael,

@MikesClub

How and when should I use it?

You can see this post by Craigo.

Many-to-many workflow creation is extremely slow: cannot add/remove users etc

A join table (collection) contains common fields from two or more other tables (collections). It helps to create a many-to-many relationship. This is what a join table looks like… [image] So the join table in this instance should be called students join classes and this stores each individual record as having a class and a student. This can then easily be filtered to show what students are on a course or what courses a student has. Hope this helps. Its a little tricky to get your head around…

@MikesClub

Please lay out an example if possible.

There are some videos on Victor’s Channel using this method : https://youtu.be/_jPUMDLVwoA

Thank you