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. :

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.

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

it has to be aligned according to time

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.