I have a database that consists of three fields: name, status and date. This is simply used to store days on which a person is actually booked to do something. The status field accepting values of 1 or zero depending if they are booked or not.

I want to display this table through a calendar inerface. Dates along the top, people down the side. The 15 columns for dates are flexible and can be either days, weeks or even months.These column/fields therefore do not have a fixed value.

I am not sure how I would start to achieve this in terms of number of tables used and how to calculate the calendar fields/columns.

I have seen examples of calendars whcih are fine for selecting dates but I am unclear how to use them for storing values from other tables.

ANy help or guidance would be appreciated.

Horizontal portals are a bit difficult in FM, but not impossible. I have attached a sample file to show one way. Please contact me with questions.

thanks Doug,

I will have a look at your solution today. In the meantime i have knocked up some sort of contraption. I will upload that later for you to have a look at too.

THank you for your time

steve

I have seen examples of calendars whcih are fine for selecting dates but I am unclear how to use them for storing values from other tables.

You could use CC Calendar for this by "pointing" the calendar at your file of bookings instead of the appointments file that comes with CC Calendar (the calendar's FAQ contains instructions for how to do this). That would let you filter the calendar by person (actually by their initials, not their name) on day or month views.

Not quite the grid you proposed, but it may be simpler.

HTH,

John

Once again, thanks for all your help. I have now knocked something together that resembles a calendar to record holidays and sickness for employees. It can be found attached in a thread entitled: calculating number of days.

It is still very woolly around the edges but is possibly the basis for some kind of time management solution.

Steve