Why is my query displaying a number not word

[Teebird]

Here is my relationships and a copy of my SQL for this query. Why is it displaying the PK number (RaceClass) instead of the word.

My table for RaceClass has the number, the query has the number but my form has the word.

Many thanks for any help.
Tee.

 

[cuttsy]

Have you made a mistake on the diagram?

RaceClasses and RaceClassLookup look like they might be labeled the wrong way round.


In any case,

If your form displayes the word and the table shows the primary key then that sounds like your relationship is behaving the way that it should.