[AccessD] Tracking question

Hi Tom,

I do this with many of my applications.  

For example, the first thing that may happen in a record is that descriptive
information is entered, so I call that a Description Stage.  The Stage is a
field in the table, which has a corresponding textbox or label (in large
bold text) on the form.  This tells the user (and the database code) where
the record is in its workflow path.  The stage is not changed by people, but
only in code.  To change the code, all the activities within a stage must be
completed - when they are the database recognizes that and changes the Stage
to whatever is next.  Form controls in previous stages are locked so no more
changes can be made when someone is making a decision based on information
in a previous stage.

For you, when the last person has approved or disapproved, this can cause
the Stage to move to what's next.

By the way, keep a StageSort integer field up to date with the Stage field
so you can sort reports by Stage, because the Stage names won't be in
alphabetical order.

Hope this helps!
Dan 
 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ewaldt at gdls.com
Sent: Wednesday, April 26, 2006 11:23 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Tracking question


Is there a favored way of tracking progress in changes? I'm speaking of a
database where records go through an approval/disapproval process at many
levels, so it needs to be kept track of. I'm looking for suggestions.

TIA,

Thomas F. Ewald
FCS Database Manager
General Dynamics Land Systems
(586) 276-1256





This is an e-mail from General Dynamics Land Systems. It is for the intended
recipient only and may contain confidential and privileged information.  No
one else may read, print, store, copy, forward or act in reliance on it or
its attachments.  If you are not the intended recipient, please return this
message to the sender and delete the message and any attachments from your
computer. Your cooperation is appreciated.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com