calendars

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been asked to create a program to monitor holidays and sick leave. The
user wants to be able to call up a screen that shows a calendar type screen
with every day of the year on it, and a code input for the days the staff
member was off (ie AL for annual leave).

Every time I try to get my head around it I keep thinking of huge tables
with over 356 fields, one for each day and one for the year, which member of
staff etc..

Can anybody get me out of this rut and suggest a more sensible way to do it?
 
It isn't clear what you would expect to see on the calendar and what is so
special about seeing all days of the year on a single form.
You may be able to get by with a temporary table for displaying multiple
days and as a text box is edited, the results are pushed to a permanent,
normalized table.
 
Back
Top