Ok, this one is waaaay beyond my -slowly- improving filemaker skills, maybe
someone who knows what they're doing can answer this one :
I want to make Filemaker 4.1 (on mac) display every date for a month, like a
calendar, but still leave space for comments for everday ( I help run a
domestic cleaning agency, and I am trying to design a database to keep track
of of what days employees are scheduled to work):
originally I tried a week 1-4 formula, but this only works for 28 day months
(doh....back to the drawing board)
the cleaning staff clean the same day every week ( usually ) , so all I need
really is to be able to count the number of wednesdays in a month ( as an
example) and pay them accordingly.
Originally I was going to use a repeating field, numbering 1-31 for everday,
but I can see problems with this when you get to 30 day months - the only
way I can think of off the top of my head is preparing a different layout
for everyday of the month, but that would confuse things even more...
SOMEONE must have an idea of how I can work around this..
Thanks in advance