JordanMcAliste1
3 years agoQrew Member
Employee Global Assignment
I have an Employees table and a Safety Topics table. I have them joined with a Safety Assignments table to achieve a many to many relationship. My overall goal is to have someone post a new safety topic with attachments in the Safety Topics table and have that create an assignment in the Safety Assignments table for every employee to review the safety topic with an automated email for the employee to "check off" whether they have completed it or not. The employees don't have access to this app - only their supervisors, which is why I want an automated email that the employee can click a link that will update their record without them actually going into the app. I think I know how to do the email for the most part, but I can't figure out how to auto-create an assignment for each employee record whenever a new safety topic is created. I want to be able to look at the safety topics table and know who hasn't reviewed the safety topic.
Any suggestions on how to do this or even if there is a different way I can achieve the same effect - thanks.
------------------------------
Jordan McAlister
------------------------------
Any suggestions on how to do this or even if there is a different way I can achieve the same effect - thanks.
------------------------------
Jordan McAlister
------------------------------