In the example above, a reference field (SupID) can be used to indicate the ID of that employee's supervisor.
Using something as simple as a DLOOKUP can return the name of that supervisor.
eg. DLOOKUP("Name","EmployeeTable", "ID = " & SupID)
Another good ex...