Routing Approval

If you're talking about building a system to do this, I would see at least these database tables:

tblDocuments - holds documents, unapproved and approved

tblUsers - list of users in the system

tblWorkflow
DocumentID UserID Approved

There would need to be a UI to specify which users need to approve the document, which could be as simple as a big list with a bunch of checkboxes, or you could define another table with a list of people who need to approve a document based on its type.

In addition, you would need to keep track of whether the document is approved or not by checking whether you have all the approvals.

This is a much bigger project than what can be described in this little box, but it's a fairly straightforward project. If you have further questions, please contact me.

- Eric