Where a table has a field for status lifecycle (e.g., New, In-Process, Pending, Complete, Void). You have a couple of options. One is to keep updating the Status field each time it changes. But if you want an audit trail of that history, you can have a child table that captures each snapshot of history. It would be nice to have it one-click automated.
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment