I have a split database that is used to enter monitoring forms, and the database has three tables one with team managers, employees and data and each team manager has 10 employees.
I am trying to create a report that shows the number of monitor forms enter during the month. If the employee has 5 forms the report needs to be sent atomically to the manager. If the end of month is today, sent report with any the number of forms for employee. (I am assuming less than five)
The report needs to be sent per individual and it needs to repeat the same process for each member of the team and then continue with the next manager.
I would like to get some help. I am very new in programing….