Many to Many Joins Tutorial?

Hi all, I'm looking for a little help and I think maybe I jumped off into the deep end already.

I'm just trying to implement a basic self-tagging system for users to discover other users in Adalo. I have a table with all the tags, the main table with all the users, and a table with a relation to both, which I think is my join table.

Yeah, and that's where I cant' find any more info on what I need, besides ChatGPT cheering me on to create a my own join table. All the tutorials I found were for one-to-many relationships and I'm pretty sure mine is a many-to-many.

Can anyone point me to some literature on how join tables work in databases or some tutorials for this kind of system? I'm just starting out, going from Airtable to Xano when trying to migrate onto Adalo when Stacker started to let me down (what a journey).

3 replies