How to find relationship which was already established?

[Helpingclients]

I’m looking at a clone app build, but there is no option here to see what the current relationship in between there databases which was set up by the original developer. I’m trying to understand if it’s set as one-to-many or many-to-one.

I’m new here and sound dumb to ask this question, but thanks in advance for looking into it.

[Flawless]

Hey there @Helpingclients

You don’t sound dumb asking that question. It’s a valid question. I get asked this question every once in a while since I sell Adalo templates through my Templar Design website.

In order to distinguish the difference between one-to-many, many-to-many, or many-to-one relationships, you need to look at both database collections where the relationship exists and see which icon is displayed.

Starting with the user collection, you can see here that all 4 of the relationship parameters for the user collection start with the “many” icon. So we know it’s many-to-____. Looking at any of the other collections, we’ll find out what the other variable is.

Here in the booking days, you see the “admin” parameter (which is simply the User relationship renamed to Admin) has a “one” icon and booking times has a “many” icon. So we know that the user-to-booking days relationship is a “Many-to-One” relationship where the user can have many booking days and a booking day belongs to a single user.