Having trouble with a pivot table.
Here's what I'm trying to do: I have episode at the top and dates on the side. I have created a table that combines the date serial and episode serial numbers. There is a field that table (Episodes_to_Dates) called Cut that I want to use to go into the field that in the screen grab says 1-1.
What I'm thinking I need is a lookup field that looks at the Ep_ID and Date Serial and shows the appropriate cut field. But I'm not terribly sure what I'm missing.