I need to come up with a design that will show all jobs per day per work center and is easy to read and change. They also need to see mutliple work centers and days at one time. I can't think of what that would look like. Here's what my raw data looks like.

Job Table has three fields I care about: Job #, Start Date, Work Center.
Work Center table that contains Work Center and scheduled - scheduled is a logical field that determins if it should show up on the screen.

So they want something that has days on one side and work centers on top (or vice versa which ever way is easeir)

I was thinking a grid with in a grid because there would be multiple jobs for a single day and work center. But to get that I would need a table for each day/work center combo because I can’t have multiple relationships into one table and have the grids show the correct data.

Does anyone have another design idea to show all this data?