Hi
I can see many examples of parent-to-child relations in Servoy. Like “customer to invoice”, “invoice to invoice lines” etc.
But in reality one can have many-to-many relationships. Like, for instance "Student to Teacher. Where a Student can have many Teachers; and a Teacher can have many Students. In this case you have to resolve the relationship with something like Teacher_Student_Usage. Where the table Teacher_Student_Usage contains nothing more than Teacher_ID and Student_ID - recording just the relationship. There is no point having a form based on the Teacher_Student_Usage table. But you would still want a Student Form with a sub-form showing Teachers and visa versa.
I can see relationships in Servoy are from ONE table to another… So, I am just looking for some ROUGH guidance on how to implement this type of relationship in Servoy… before I start messing around…
Thanks in advance.
Kind Regards
Jonathon