Playschedule

[bartus991]

In MS Access 2010 I want to create a kind of showschedule for a small cinema. I can't figure out how to create this correctly. This is what I want to create:

-                 Week 26 (23-06 - 29-06-2005)         Week 27 (30-06 - 06-07-2005)
Auditorium 1     |> A1 A2 A3 E1 E2 E3   MTWTFSS >2    |> A1 A2 A3 E1 E2 E3   MTWTFSS >1
                 Movie 1                Final         Movie 3                Changed

Auditorium 2     |> A1 A2 A3 E1 E2 E3   MTWTFSS >|    2> A1 A2 A3 E1 E2 E3   MTWTFSS >|    
                 Movie 2                Final         Movie 1                planned

Normally I would say a pivot table would be a good solution. Vertical: the auditoriums, horizontal: the playweeks. In the middle, the movies with the details. But the look of a pivot table can't be customized.

This is the information that's shown:

Upperline:
 - Information about the previous week: |> means first playweek, 2> means last week the movie played in auditorium 2.
 - A1 A2 etc. Are predefined time codes. This information has to be looked up in a SubTable.
 - MTWTFSS are the days of the week
 - Information about the next week: >| means last playweek, >1 means next week the movie playes in auditorium 1
Second Line:
 - Movie 1: movie name
 - Final: Status of the movie

The tablestructure:
- The Masterrecord is held in the Movie Table, al details about the movie.
- Per playweek a record will be created in de PlayweekTable which contains mainly the auditorium details and some other information which applies to the whole week.
- The for each show a subrecord will be created. Each movie contains a playdate and playtime. For each time a timecode is define. Like 12.00 = A1, 14.00 = A2 etc.

I hope some one has an idea what the best solution would be.
Some weeks can have two movies per Auditorium which makes it a bit more complicated for a simple continous form as it needs two colums.

 

[bartus991]

Just thinking...
Is it possible to create a pivot table in MS access, displayed as form/continuous form?

 

[MajP]

How many weeks are shown along the top? Is it fixed (like a one month schedule) or dependent on the child records? Are the time periods fixed like you show or do they vary with the child records? How many auditoriums are there? You show a single movie taking all the time slots for a given week, is that always true?
If these values are fixed then it might be easier to build an unbound form/report. A crosstab query can be used as a forms recordsource, but what you show may be a too complex for a crosstab. It is hard to tell without knowing the table structure.