Hi
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:
StudentId
StudentName
Parents-> ParentName
ParentRelation
ParentId
My Families Table Has two columns type ref
StudentId
ParentId
According to what I read, I create a Virtual Column In Students Table, type List with the formula
SELECT(Families[ParentId], [StudentId]=[_THISROW].[StudentId]).
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?
thanks
Claudio
LinkedIn
Twitter
