This content has been marked as final. Show 1 reply
I have figured out that the problem is with my database structure not Vista...
I'm trying to set up a many-to-many relationship between two tables "tutors" and "students" using MS Access 2003/2007 and Flex Builder 2's Coldfusion Flex Application Wizard. I have created a junction table "link_students_tutors" containing both tutor_id and student_id (as primary keys) from the corresponding tables. I then create one-to-many joins from both tables to the junction table (as per various documentation online) and save the relationship.
My problem occurs when I attempt to set up a detail page in FB2 Coldfusion Flex Application Wizard. I am trying to set up a tutor detail form where each associated student is displayed below in a table. When I add the tutors table, the junction table and create a one-to-many (tutor_id to tutor_id) join this works fine. However when I add the students table to the query builder and create the second one-to-many join (as per online documentation) I receive an error:
The following tables have more than one many sided joins attached to them "link_tutors_students"
The following tables are starting tables meaning the form is not a single entiity:
If i change the join link_students_tutors to students to a many-to-one (reverse the join) FB2 crashes and I receive the afore mentioned JVM error.
Setting up the database with only one-to-many joins (ie. tutors-students joined by foreign key of student_id in tutors table) everything works fine. However, students can also have multiple tutors therefore this design is insufficient.
Does anyone know how to get the FB2 Coldfusion Application Wizard to display multiple tables on a detail page using a many-to-many relationship.