A Layout and Programming Nightmare

[caseavey]

I am working for a filmfest where we are going to develop a day to day calendar based on start time and end time of the program. The only part i need help with is to develop some way to arrange the movies and special programs so that it is arranged in a grid. The boxes must display information about the movie and tech info.

The database in which the information will be inputed into has already been built. The only thing i need to develop is an external database that shows a day to day grid for everything going on.

Also, to make it even harder, it all has to be in FM6. I have been trying a lot of things (related fields, etc) and i have drawn up blank.

God Speed. :

[Fitch]

In the calendar file, create a date field for each day of the festival and make a relationship from each date to the date in the events file.

(You could do this in the same file, using global date fields and self-relationships.)

Put each date field on a layout. Underneath each date put a portal that shows related events.

Tedious layout work but there's no way around it.

[caseavey]

And i also forgot to say that there are upwards of 14 venues on one single day. :blond:

[caseavey]

it has to be aligned according to time

[Fitch]

Using the method described above, the relationships can be sorted by time.

If everything needs to align, you'll need to make sure that every time slot has a record, even if it's empty.