Many to many relationships

C

Chris

Hi All,

Many to many relationship.

I have this many-to-many relationship: 2 primary tables, and a junction table.

2 primary tables:
tblSkillsDescription (PK): SkillID
TblTraining courses (PK): 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Many to Many relationship 1
Form and subform with a many to many relationship 7
Multiple Many-to-Many relationships 10
Assistance with Many-to-Many Relationships 6
Adding data to MS Access from csv file 0
Design help for community group database 6
Many to Many Relationships 4
relationships of 3 tables 6

Top