Kevin,

I know barely enough to be dangerous on this topic, but this sounds like the perfect scenario for using Windows Workflow Foundation (or simply WF). This is probably not the best link (http://social.msdn.microsoft.com/Search/en-US/?Refinement=-111%2c-112&Query=Workflow), but maybe it'll get you started.

Beware, it's pretty difficult to "grok" ... so, you may not want to use it right now. But, this is exactly the kind of thing it's made for.

Unfortunately, you can't ask me questions about it ... we used it at the company where I previously worked, but I personally did not design the framework we used for it, so as I said, I know next to nothing about it.

~~Bonnie




>I'm working on an app for a client that has various roles defined. The app creates a COSProject record which needs to go through stages in which various people in the roles changes/approve/disapprove the record.
>
>In some cases, say until a certain dollar amount threshold is reached, the record can be sent to the next stage without approval. In the cases where the dollar amount reaches or surpasses the specified limit, then it cannot be sent to the next stages without approval. In all cases, when the record reaches the Purchasing stage, it all required approvals are not there, it cannot be purchased.
>
>The question is: How do I set this up in the data and/or the app? I have the users, roles, and rights tables set up. I'm not sure how to define the stages in the data and to ensure the COSProject record is at the correct stage.
>
>Thanks