Good afternoon friends.
I am trying to create a relationship in the database and a list showing this relationship.
I have a collection of users and one of events. An event can have multiple users and a user can have multiple events.
When I set up the list, I choose the data source to be the users collection.
I can show the name of the user, but not the name of the event that is saved in the event collection and if I change the data source to the event collection, I can show the name of the event, but not the user to whom it is related.
Could someone explain to me how I can show the name of the user who created the event and at the same time the name of the event if they are stored in two different collections, but related to each other.