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