By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

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

P: 37
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?
Jun 19 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 100+
P: 2,321
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!!
Jun 19 '12 #2

P: 37
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.
Jun 19 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.