ms-accessSelf-Referencing tables


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 example of this is to look at how automated Access switchboards are created, and more specifically the construct of the Switchboard table. Each switchboard option refers to another option within the same table - similar to how this example self references.