Issue with Join Query

[KristenD]

I am trying to use a join query to join two tables in order to create a form. I have done this on two other occasions in my database with no issues. Now it is only pulling the ID and I want it to pull the description. I have looked at the SQL view for the other queries that are similar as well as the design view and all of them are set up the same way with the exception that this new join query is pulling CertID rather than the CertDescription.

Is there any reason why it would be doing that? Is there an error that I could possibly be doing? It seems according to my notes that I have created all the queries the same but this last one does not pull the same info as the other queries.

Thanks in advance!

 

[bob fitz]

Perhaps you need to add the Certs table to your query. Join it to one of the existing tables using CertID and the and CertDescription to the fields in the query.

 

[jdraw]

Can you post a jpg of your tables and relationships?