Hello, I'm a newbie that is trying to expand the usefulness of a 2007 DB all ready in place at work. It is a drafting firm. The drawing records with all the data are kept on one large form with everything visible. Drawings have a 3 step lifecycle from inception to delivery.
What I would like to do is have a large, colored "status" box on a drawing form. This status box would display one of three things: "not started", "in drafting", or "released".
We already achieve this, but by using three date fields: "date received", "date completed", and "date approved".
Hard to look at those and determine status fast enough.
So, ideally:
"date received"="not started"
"date completed"="in drafting"
"date approved"="released"
Can a user trigger the appropriate status when a date is entered (not null)?
I'm trying to understand how once a qualifier is met, a new value like that can be added to the record.
Again, I'm on an Access crash course..any pointers are greatly appreciated.
thanks
Sim