christimess
Programmer
I am creating a report that uses the following tables:
PS_Job, PS_Personal_Data, PS_Employee_Review, PS_Jobcode_tbl and the Xlattable table (translating the review rating from the employee_review table). When I finish creating the reports I have over 2200 records. When I close out of the report and open it up the record count changes to just over 800. Every time I remove the PS_Employee_Review table it fixes the problem. In my table link I have the Personal_Data table linked to the Employee_Review table, and under Personal_Data I have checked the box for including unmatched records. Does anyone have any suggestions on why this is occuring and how I can go about fixing this. Thanks for everything!!!!
PS_Job, PS_Personal_Data, PS_Employee_Review, PS_Jobcode_tbl and the Xlattable table (translating the review rating from the employee_review table). When I finish creating the reports I have over 2200 records. When I close out of the report and open it up the record count changes to just over 800. Every time I remove the PS_Employee_Review table it fixes the problem. In my table link I have the Personal_Data table linked to the Employee_Review table, and under Personal_Data I have checked the box for including unmatched records. Does anyone have any suggestions on why this is occuring and how I can go about fixing this. Thanks for everything!!!!