I have a table of student data. I'd like to create links between students who are siblings. This requires a many-to-many, self-referencing relationship: each student can be linked to more than one sibling, whose records all reside in the Students table.
Is it possible to build this type of relationship within Caspio? I have created a second JOIN table to link students who are siblings, but I am having trouble creating a view that ties them together in the appropriate way.
I am a brand-new user, so detailed advice is appreciated.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
KatrinaE
I have a table of student data. I'd like to create links between students who are siblings. This requires a many-to-many, self-referencing relationship: each student can be linked to more than one sibling, whose records all reside in the Students table.
Is it possible to build this type of relationship within Caspio? I have created a second JOIN table to link students who are siblings, but I am having trouble creating a view that ties them together in the appropriate way.
I am a brand-new user, so detailed advice is appreciated.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.