Hi, hoping someone can help! I've got a web app, with three tables: Projects, Tasks and Staff.
In the tasks, there is a section for who the task is assigned to - a lookup value from the staff table. I have managed to successfully create a macro where on insert the email address of the person...