Relating two records on a table
We use our database for standard constituency tracking for our arts organization. We track records of individuals that take part in our programs (generally youth), donors, parents, etc. In particular, we have a camp every summer and we track both participants and their parents. These are related through 'groups' that we create. That way on a camper's record we can see who their relatives are and how they are related.
I can't seem to find a way to relate two records to one another in the table view. I want to be able to view a table in which I can add a column that displays the main relative to the record in question. For example, if I were to query for campers in our past programs, I would also like to see who their parents are. Is there a way to do this?