I am trying to figure out how to have one table lookup the contents of another and display it as a table in detail view.
Basically, we have volunteers that sit on panels. I want to be able to see who sat on the panel as a list within the detail view of a panel row. I’ve set it up so that each volunteer row has a multi-select list of panels, which are lookups to a second table. Is this the wrong way to do it - should I have set up the panels as the main table with lookups for the volunteers? Is there an error with doing things the way I’m doing? Some sort of circular referencing issue?