Copy relationships

I have a database

Collection: Users
Collection: Groups

In groups there are a name and users.
Group A, Users 1, 2, 3
Group B, Users 1, 4, 7

So far so good. Easy.

Now I want to add a record in another collection:


Normally, a session has a column called: Users. In there there is a series of uers. However, through groups, users do not have to select the users every time manually.

So new session and instead of user 1, 2, 3, we now pick Group A which then should copy all the users to the Sessions Collection. Is there a way which is not hacky and workaroundish?

Thanks in adavce!

@desmet, in the sessions collection you can create a relationship with the groups and then you can access group’s > users when displaying.