Hello. So I have two tables project info and daily reports. The project info tables lists projects with their information, including who the foreman is and their email address. The daily reports table lists all the daily reports data collected in a form, including the project name which pulls from project info table. The present security filter checks for the user email versus a hidden column that appends the users email to each record. Problem is if I edit a record (I gave myself god like access to work as needed) it appends my user email. So then they lose access. What I want to do is have an additional dependent email appended to the record every time where it checks to see what project is selected in the record during the form editing and always has the foremanโs email for that project added to the record as well. I will then check that in an OR statement for the filter. Make sense? Just want some help with the syntax to get the lookup right so that the foreman emails for only that project from project info is chosen and added to the daily reports column.
Thanks!
LinkedIn
Twitter
