AnsweredAssumed Answered

One to Many report setup

Question asked by enstorms on Jan 4, 2019
Latest reply on Jan 4, 2019 by jbrown

Have an Employee table and a Records table.  Records table holds yearly training assignments for each employee with training due dates.  Needing to create a monthly report showing training due for current month and next month.  Using table occurrence Employee_Training joined to the records table.  Only want active Employees shown.  Have a field "Status" (Active/InActive).  Can get this.  However, don't know how to script the find for the related table.  I set a variable to next month, then request all records < or = to that variable.  However, only picks out one record for each employee.  Was using just the Records table, which worked, but shows all, including InActive employees. Any help greatly appreciated.

Outcomes