master-detail pages with many to many relations?
Hi all,
I need to build a master-detail back-end with WA databridge.
I know how to create basic master/details using the WA dataAssist pages server behaviour.
But what about using many-to-many relation with these pages?
Example:
I have 3 tables:
1- students
2- courses
3- students-courses
The table 3 contains only two field with 2 foreign keys: userID, and courseID
Every student can attend more than one course;
How can I create a user detail page that allow me to edit user data along with the course he can attend to?
I used ADDT (again!) in the past and this was "almost" easy.
With ADDT, once you applied the many-to-many server behaviour you were able to get a student detail page with all fields from the students table and a number of fields (checkboxes) (the number depends from the number of courses available). Thicking the courses checkboxes for the specific 0student you're editing will create multiple records in the table 3.
Basically I would like to edit the students records and add the ability to specify the courses a student can attend.
Is there a way to get something similar?
TIA
tony