# Help with creating many-to-many relationships between two tables **URL:** \ **Category:** Ask for Help\ **Created:** [September 18, 2023, 12:56pm UTC](https://community.glideapps.com/t/help-with-creating-many-to-many-relationships-between-two-tables/66259 "2023-09-18T12:56:48Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\ **Post date:** [September 18, 2023, 12:56pm UTC](https://community.glideapps.com/t/help-with-creating-many-to-many-relationships-between-two-tables/66259/1 "2023-09-18T12:56:48Z")
l want to create a many to many relationship between clients and brands with a joining table. - such users will be able to add brands to a client. They can do this by into the client details while adding a survey. -If the brand does not already exist, they will be able to create a new brand ![brad](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/8/3841833dbbd4c4247ae5ffe9503296551d668ff5.png) ![brad0](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46fda70d97c3508b157a271a5f30dbca43b2a64e.png) ![brad1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7cbe36f04f556e3ef3550a7c29b9631c98bdb506.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 19, 2023, 12:30am UTC](https://community.glideapps.com/t/help-with-creating-many-to-many-relationships-between-two-tables/66259/2 "2023-09-19T00:30:27Z")
> [@Teejay\_Oyeniran](#): > > such users will be able to add brands to a client. They can do this by into the client details while adding a survey. So do you mean you’ll have a column to determine which brands (multiple allowed) are related to which clients? If that’s the case, I would show a multiple choice component in each client’s add/edit screen to choose which brands are related to the current client, and add a form button just below that choice so users can add new brands, when needed. This is assuming a brand can be related to multiple clients. ---
**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\ **Post date:** [September 19, 2023, 1:22am UTC](https://community.glideapps.com/t/help-with-creating-many-to-many-relationships-between-two-tables/66259/3 "2023-09-19T01:22:25Z")
Yeah, you are absolutely right… is there a resources or tutorials videos that can help me in creating such relationships ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 19, 2023, 1:52am UTC](https://community.glideapps.com/t/help-with-creating-many-to-many-relationships-between-two-tables/66259/4 "2023-09-19T01:52:23Z")
> [@Teejay\_Oyeniran](#): > > tutorials videos that can help me > [@link Glide Relation Basics](https://community.glideapps.com/t/glide-relation-basics/50959): > > Hey all! I’m releasing a mini series all about the Relation Column in Glide. Before I create tutorials on more intermediate topics such as conditional relations, crafting matching values, or navigation and data generation via relations, we need to start from the beginning. To kickstart the miniseries, here’s a tutorial on the basics of creating relations in Glide. play_button Wait...what's a Relation in Glide? Enjoy! [[Glide 101: Relation Column] ](https://www.youtube.com/watch?v=ecJy1hvfb-U) Also, if you’re brand new to Glide, make sure… > [@Things in Things | Glide Tips](https://community.glideapps.com/t/things-in-things-glide-tips/35686): > > This is probably one of the most common patterns in Apps & Pages and yet it’s a little tricky to get your head around when you’re new to Glide. So we thought we’d do a short video, summarising the basics: [[Things in Things | Glide Tips] ](https://www.youtube.com/watch?v=2lZ75iPXc2E) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 19, 2023, 6:51am UTC](https://community.glideapps.com/t/help-with-creating-many-to-many-relationships-between-two-tables/66259/6 "2023-09-19T06:51:57Z")
> [@hotToddy](#): > > Is the trebuchet method one worth learning?; even though there have been a lot of Glide updates. I remember you saying it was good for a particular use case. but, not for others… I may need to rewatch that one. Trebuchet is a useful technique to have in your Glide toolbox, but I think Bob would agree with me when I say that its uses these days are limited. For example, you can often get the same result with a simple multi-select choice component. One of the primary inspirations for Trebuchet was that we didn’t have a multi-select option back then. My advice would be to learn how to work with JSON data structures, as these are much more powerful than anything you can do with Trebuchet. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 20, 2023, 1:06am UTC](https://community.glideapps.com/t/help-with-creating-many-to-many-relationships-between-two-tables/66259/7 "2023-09-20T01:06:44Z")
> [@Darren\_Murphy](#): > > My advice would be to learn how to work with JSON data structures, as these are much more powerful than anything you can do with Trebuchet. I agree with this. Ever since Darren told me to use JSON more, especially in Make, my data structures are much better than before.