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.