Mant To Many Relationship Issue

[CharlesWhiteman]

I've attached a copy of my Db. I'm trying to setup an enquiry system where I'm recording enquiries against courses. Many enquiries can be linked to many courses. The issue I am having is that when I try and create a one to many relationship between the CourseID and the CourseIDFK in the link table it only offers an indeterminate relationship rather than one to many. Any help/advice much appriciated.

 

[Kryst51]

I think it is because your CourseIDFK was not defined as the primary key.

 

[boblarson]

Yep, that is the problem. See attached revision.

 

[CharlesWhiteman]

Yeah, It sure was! Thanks guy's.