Hi there. I am very new to Glide and have watched several videos online to get going. I am building an app to keep track of sports teams and results. So I have one table with all the players names in it, and one table with all the team names in it. The relationships need to be “many-to-many” so each…

hi mills, add relation columns in both tables and select “match multiple”

You should choose to store this type of relation in text form in one table. If you choose the teams table, have a column to store a comma-delimited lists of player IDs for each team. Split them into an array using the split text column, and relate that to the players table. In the players table, cr…

Is it a bad thing to have relation columns in both tables?

I think it depends on what he’s trying to do. If I need to display which teams a player belongs to, and which players belong to a team, then I would need relations in both tables. The key point is the information should only be updated on one side.

Thank you for the reply. I have found a few things that I am trying! Like I said, I’m very new to Glide so will figure it out

I’ve done this. How can I filter a view of my many-to-many? For example, I would like to click on a player and see a view of which teams they are in? Thanks

[image] Hide/show rows in a single collection based on user type Ask for Help You should be able to use a Screen Filter. UserEmail is Screen->UserEmail (please avoid cross posting the same thing to multiple threads)

[image] wfmills: I am not sure how to do this as all the videos I have watched show a “1-to-many” or “many-to-1” relation Welcome to Glide. My approach to building changes all the time, but for the past few weeks I have decided to stop overthinking many-to-many relations. If there is one, I …

Many-to-many Relations

Ask for Help

Darren_Murphy October 3, 2024, 10:37am 8

(please avoid cross posting the same thing to multiple threads)

Topic		Replies	Views
Troubleshooting Many-to-Many Player-Team Relationships in sport club app Ask for Help	3	23	April 6, 2025
How to make a "2 ways" relation between tables? Ask for Help	3	741	February 18, 2023
Many to many relationships Ask for Help	10	2193	January 21, 2024
Official Glide many to many relation approach Ask for Help	0	252	March 24, 2023
Many to many relations Ask for Help	5	316	June 16, 2023

Many-to-many Relations

Related topics