OK here is the scenario. I have a table, "SMEInfo", with the field "Email".
The "SMEInfo"table has a primary key of "SMEID". The "SMEName" is selected
from a dropdown box and stored in "SMEStatusTable" in the field "SMEDesc".
The dropdown box is in a subform that is connected to the primary form via
"CaseID#". My issue is that I want to have the "Email" to populate in the
"TO" area of an email for the current record only. I can't seem to get
Access to recognize the current record that has the same "CaseID#" in Both
the Primary table and "SMEStatusTable" to return the "Email" address that is
associated. Oh, just in case anyone is wondering, the reason that the data
is stored in another table is because there can be several "SME"s for any
single case.
Thanks
--
Jonathan
Microsoft Office (other)