If you click Diagram View in the View group, you’ll see a diagram of the one-to-many relationship between the two Table objects, as shown in Figure F. Now you can create a PivotTable based on ...