Because employees [EmployeeID] report to other Employees [ReportsTo]. An order belonging to another order hurts my brain.
Andy Gaskell
2009-08-22 02:03:44
Because employees [EmployeeID] report to other Employees [ReportsTo]. An order belonging to another order hurts my brain.
The EmployeeID is probably being referred to by the ReportTo field. For example, a given employee reports to another employee, using EmployeeID as the reference.
The OrderID does not point to the Order table because there are no other fields in the Order table that uses/refers to the OrderID.