I have a simple database where I need people to update information via the "create email" function.
The database is essentially two tables and a query.
"TblFaculty" has "FacultyID" as a primary key. "LastName", "FirstName" and "Email".
"TblDelays" has "ID" as a primary key. "FacultyID" which is related to the other table. There are a few other fields to track information here.
The query I'd like to run the email off of (qryDelays) has "FacultyId", "Email", "name" (which is a combination field of First and Last names in TblFaculty). And a few other fields from TblDelays.
When I highlight the qry and hit Create Email, it does not give me the option of choosing whether I want to collect new data or update existing data, it's new data only which is not what I need. When I highlight either of the tables, it IS presented as an option, but the email needs to run off the qry. Any help would be appreciated, Thanks. -Matt
The database is essentially two tables and a query.
"TblFaculty" has "FacultyID" as a primary key. "LastName", "FirstName" and "Email".
"TblDelays" has "ID" as a primary key. "FacultyID" which is related to the other table. There are a few other fields to track information here.
The query I'd like to run the email off of (qryDelays) has "FacultyId", "Email", "name" (which is a combination field of First and Last names in TblFaculty). And a few other fields from TblDelays.
When I highlight the qry and hit Create Email, it does not give me the option of choosing whether I want to collect new data or update existing data, it's new data only which is not what I need. When I highlight either of the tables, it IS presented as an option, but the email needs to run off the qry. Any help would be appreciated, Thanks. -Matt
