I have these collections:-
Users (name, role, group)
Sessions (session_id, name, qty)
Production Jobs (session_id, sku, qty, group)
I’d like to display a list of Sessions for the logged_in user. I’m struggling with this as group is a field in users and in production jobs but not in Sessions.
The link between users and sessions is only via Production Jobs but I don’t want to display each production job, just the sessions where a user has a production job - if that makes sense?
I’d be so grateful for any help - this is my first post and I’m a new user.