Here’s the issue:
I have 2 tables: Sessions and Users. This is a many to many relationship so there is a junction table sessions_users between them.
When viewing Sessions I would like the inline view to show a list of Users and vice versa. The issue is that viewing Details of either table shares the same inline view sessions_users_inline, so the information displayed can be confusing. If the inline view were a card it looks something like this:
Sessions Detail View :
Related sessions_users :
Users Detail View:
BUT, I would like to reverse those, so that viewing the Users Detail shows
Is there a way to have 2 inline views and force one or the other? CONTEXT() doesn’t seem to work because it returns the inline view, not the “enclosing” view, and is not reliable in a virtual column anyway.
Any ideas? I can do this in whatever way seems to yield the desired results. Thanks!