Questions - where are you getting the number of terminations and warnings? Is each row a single warning? and in the terminations dataset, is each row a termination?
Hi Mike, thanks for getting back to me so quickly.
I am getting the warning notices from: 'form_hr_warningnotice' and the field is 'number of employees'
I am getting the termination notices from : 'form_hr_termination' and the field is 'termination type' which is I or V.
Both tables share a few fields, for example fileno, employeeid, but these are not primary keys in SQL.
Ok, and you want to see which employees were terminated and also received warnings beforehand?
If that's the case then you need a new datasource that is a list of your employees, where each employee is listed once. That's your primary table to relate to the other two.
If it's the number of terminations and warnings by manager, then you need a table that just lists each manager once.