I have two tables.
“Students” and “Parents” which I need to use to build a detailed wiew on each other.
Each student may have more than one parent (Father, Mother, other), and each parent more than one student (brothers or Sisters).
So I set up a Bridge table “Families” containing each relationship.
Fristly I would like to have a Students view in which I can see all realted Parents:
so fields may be:
My Families Table Has two columns type ref
According to what I read, I create a Virtual Column In Students Table, type List with the formula
Only get a list with the ParentIds.
How can I get a detailed view of all Parent Data for each student?
Or the only way is to add all Sudent Data and Parent data to the bridge table Families?