JoeMann
|
| Posted: 07/02/2003, 11:15 AM |
|
I have a table which has project info, within that table is a variable which represents the ID of a tech assigned to the project. When the project is put into the database I want to be able to email the person it was assigned to.
I know how to do the email part and from where, but I don't know how to get from the employee table the value of the email address to stuff into the email to: address. So a recap.
project_table
employee_id
project_details
employee_table
employee_id
email_address
And from the inset grid of the project table I am trying to relate via employee_id back to the employee table to obtain the email_address?
Any help or samples greatly apreciated...
Just in case using PHP w/Templates.
Thanks !
|
|
|
 |
Steve Wells
|
| Posted: 07/02/2003, 6:07 PM |
|
The CCDLookUp function (see help) allows you to pull data. Here is from the help:
CCDLookUp(ColumnName, TableName, Where, Connection)
So specify the column which contains the tech's email, the table that contains the tech email, a where statement such as "employee_id=<your value>" and which connection has the data. I've been done something similar and have luck with it. They have several examples in the knowledge base of using aspemail with the ccdlookup function in it.
---Steve
|
|
|
|
|
