Yes, an interesting question...
Difficult to answer. The form is a scheduling screen. If you can imagine my
columns as days, rows as customers, and cells representing a sales rep to
call on that customer on that day (Not exactly what it is, but easier to talk
about).
Based on data retrieved seperately which define how long before a customer
is due his next call (This info varies based on factors like usage, stock
levels etc... all monitored by us), I am trying to graphically show the form
user / scheduler when the next call should be due.
Line colour would change from green (OK) through amber (Hit predefined
restock level) and red (low stock) accross the days for each customer. The
scheduler's task is to optimise calls so they are not to early, but not to
late, in the amber zone.
I can't individually set the cell background colour to achieve this (And
would only show the whole day rather than a portion). My thought is to have a
'skin' I can turn on / off that gives the graphical third dimension accross
the displayed records.
If I increased the cell height I could paint the lined above / below, but if
the lines are solid I get the feeling the data will be hard to read. Other
suggestions welcomed.
Thanks for the note.
swas
