Help with relationships

[timbl]

I am trying to create a database for recording boat race results.
The set up is as follows...
There are boat classes which contain boats...
Classes have a number of series throughout the yaer which would consist of several races...
Each race has a number of entrants with respective results...

Everything is going okay except that when I try to create a form to select boats to enter a race from a series - which is itself part of a class and therefore should only have that classes boats to choose from - I cant seem to be able to create a dropdown box which only gives me boats from the specific class.

I hope this makes sense!

I have attached relationships screenshot.
Many thanks

 

[jdraw]

You should be able to get boats in a Class from your table

tblClassM... the name is not completely visible in your jpg since the "Box" was not expanded.

If you do something like

Select Boats from TblClassM...
Where Class = yourDesiredClassHere

you should get all the boats in the class.