There is a race list database. each race can have many users. there a property registered (true/false) that should enable users to enter that status in their profile page. When displaying the races in a list i would like to show the registration property for all users in the group to all users in the group for each race. I am new to Adalo so I wonder how I have to realize this.
Thaks for help…
Hi, Welcome to the Adalo Community.
If you simply want to connect users and races, Adalo allows a basic many-to-many relationship between the User and Race collections. This setup is fine if all you need is to know which users are linked to which races, without any additional data about that connection.
However, in your case, you want to track whether a user is registered for a race, a true/false status (and other properties) that’s unique to each user–race pair. This requires storing additional information about the relationship, which a basic many-to-many link cannot do.
To solve this, you should create a custom join collection, commonly called something like RaceUser. This collection sits between User and Race and connects one user to one race, while also allowing you to add fields like Registered.
In this RaceUser collection, you’ll have:
- A relationship field to the User
- A relationship field to the Race
- A true/false field named Registered
With this setup, you can let users update their registration status, display it on their profile page, and show all users registered for a particular race in the race list. It gives you full flexibility to manage and display registration data.
Let me know if you’d like help setting it up step-by-step.
Woow this is extremely helpful and clear. I will try and ask for further help if required. Many Thanks 
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.