Help with creating many-to-many relationships between two tables

[Teejay_Oyeniran]

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

[ThinhDinh]

@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.

[Teejay_Oyeniran]

Yeah, you are absolutely right… is there a resources or tutorials videos that can help me in creating such relationships

[Robert_Petitto]

@Teejay_Oyeniran

tutorials videos that can help me

Glide Relation Basics

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.

Wait...what's a Relation in Glide?

In Glide, a Relation is a column type that allows you to connect two sets of data. Typically…

Things in Things | Glide Tips

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]

[Darren_Murphy]

@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.

[ThinhDinh]

@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.