C
Chris
Hi All,
I have this many-to-many relationship: 2 primary tables, and a junction table.
2 primary tables:
tblSkillsDescriptionPK): SkillID
TblTraining coursesPK): CourseID
Junction table:
TblAssessmentRecords.
(PK): AssessRecordID
The junction table contains the 3 primary Keys (PK): AssessRecordID, and 2
others from the 2 primary tables:
SkillID
CourseID
Each primary table has a one-to-many relationship with the junction table.
What I am trying to achieve in form and subform is the following: 1 given
skill has many related training courses, and vice versa, 1 given training
course can have many skills. Example:
Electrical maintenance skill:
- Voltage course 1
- Wires course
- Work in tunnels
I would like also to be able to use this for reports as well. So far I can
achieve the look fine with the possibility to open the course list via a
combo box but the database does not let me pick more than 1 choice.
I have tried with referential integrity, but I always end stuck.
Any help appreciated.
I have this many-to-many relationship: 2 primary tables, and a junction table.
2 primary tables:
tblSkillsDescriptionPK): SkillID
TblTraining coursesPK): CourseID
Junction table:
TblAssessmentRecords.
(PK): AssessRecordID
The junction table contains the 3 primary Keys (PK): AssessRecordID, and 2
others from the 2 primary tables:
SkillID
CourseID
Each primary table has a one-to-many relationship with the junction table.
What I am trying to achieve in form and subform is the following: 1 given
skill has many related training courses, and vice versa, 1 given training
course can have many skills. Example:
Electrical maintenance skill:
- Voltage course 1
- Wires course
- Work in tunnels
I would like also to be able to use this for reports as well. So far I can
achieve the look fine with the possibility to open the course list via a
combo box but the database does not let me pick more than 1 choice.
I have tried with referential integrity, but I always end stuck.
Any help appreciated.