I need help with performing two lookup's against the same table. I am attempting to create a report that shows when a file was submitted by an operator and when that file was approved by an officer.  Both the operator and officer are employees with entries in the employee table.  The file submission and approval records are in a submission table.  I want to join the submission table to the employee table twice: once on the operator ID and a second time on the officer ID.  

When I generate a report of files submitted by operators, the report correctly displays the name of all operators who submitted files.  When I attempt to pull the report of all officers who approved files, the report still returns the list of operators.  Is there a way to reuse a single lookup table for both operators and officers, or do I need to maintain a separate lookup table for each type of employee?