ms-access Self-Referencing tables

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Remarks

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.



Got any ms-access Question?