Noob needs help! LOL!

[Bird_FAT]

[FONT=&quot]Having read the 'How to ask Questions' link - I realise the thread title is really unhelpful to you all!
I have, therefore, opened a new thread with a better, more descriptive, title:

Relationships and Bound Columns - is it table related?

Sorry for making such a noob error!

Bird
[/FONT][FONT=&quot][/FONT]

 

[stopher]

The courses all link to exams (not talking ‘in Access’ here) – what I want to be able to do is choose an exam in the main subform and have that limit the list of courses that you can choose and see in the courses subform.

So are you saying that an Exam has many courses? Also can a course apply to different exams?
Chris

 

[Bird_FAT]

So are you saying that an Exam has many courses? Also can a course apply to different exams?
Chris

Hey Chris,

Yes - there are a few courses that can apply to different exams. I was thinking of adding a unique reference to the table - i.e Autonumber so that I could change it to the primary key, and thus repeat the few courses that have multiple exams.

[FONT=&quot]Bird[/FONT]