How can I reference a related table when using a send email macro. Microsoft Access.

[Corwin Moyne]

I have an access database. I am using a send email macro to automatically send an email when a condition exists, but I cannot reference a related field in a related table.
I keep getting a message in the log saying "The identifier '[tbl Job References].[YR Number]' could not be found."

Can this be done?

[TheSmileyCoder]

Related field related table? Related to what? When a condition exists? Which condition? How is it triggered? Your question lacks alot of information. If you expect anyone to use more then 10 seconds helping you, YOU need to spend more then 3 seconds writing the question!!

[Corwin Moyne]

OK, so I have a table called "tbl_JobReferences". This is linked to another table called "tbl_colours". Each colour has a quantity, and when this quantity reaches 0, a send email macro automatically reorders this colour. But I need the reference number for this set of colours which is found in the parent table, "tbl_colours", but I cannot get it to reference this table. I have researched this and it has been confirmed that the send email macro cannot reference related tables, but it does suggest there may be a work around; it just does not say what this work around is.