In TimeXtender, Table Relations and Conditional Lookups are created by dragging a field from the source table onto the related field on the destination table. For more detailed information, please see Table Relations (in the Selecting, Copying, and Relating Tables article).

Steps:

1. Relate DateValue in Date table to OrderDate in SalesOrderDetail table
2. Relate DateValue in Date table to ShipDate in SalesOrderDetail table
3. Relate CustomerID in Customer table to CustomerID in SalesOrderDetail table
4. Relate ProductID in Product table to ProductID in SalesOrderDetail table
5. Relate SalesOrderID in SalesOrderHeader table to SalesOrderID in SalesOrderDetail table