I have a report which I need to link multiple tables to fields to pull the data I need. I am linking general employee data table to a salary table, which holds supervisor names. The need is to have the next level of data for the supervisor employee data. I have setup the employee links and additional alias tables for the supervisor general data with left outer join. The thing is the main field link (employee id) is missing for the supervisor information, so I must link by last and first name fields. What I am not understanding is some of the data appears and then it skips to the next name. Not sure why this is happening. See attached report.
Linking EMGS > EMCS Supervisor Last Name > alias EMGS Last Name and trying to match first name fields.