Monthly view with portals ?

[R2D2]

Hi !

I ran into serious troubles when trying to build a work flow -solution. I have two tables: employees and Work places. I would like to set all these in one page as a matrix, so that there is date in column (vertical) and Work Places as upper row (horizontal). In each row there is a name of employee who has made a reservation for this date and place. Hope you understand what I mean. Is this possible to do at all ? I've lost my nerves with this already...

Or is portals the right tool for this at all ?

Thanks in advance !

[comment]

It's possible, but not quite simple - not something I would recommend to novices to undertake.

Before you start, you'll need a third table of Reservations (a combination of EmployeeID, WorkPlaceID and a date). Then you can start building a calendar-type of display for the reservations (which are basically events of a calendar). The following threads might get you started:

A simple roster:

http://fmforums.com/forum/showtopic.php?tid/163163...

A full calendar:

http://fmforums.com/forum/showtopic.php?tid/176396

[R2D2]

Thank you so much ! I'll try with those examples.