Full Version: Purchase Order Approval
UtterAccess Forums > Microsoft® Access > Access Forms
martinshear
I have designed a Purchase Order form. This requires several levels of approval. At each level the approver forwards to the next level with preferably an email notification.

Any ideas would help?
Steve_Woodhouse
Can you provide a bit more information?
ScottGem
How do you determine who the next level is? Is it the same for all POs?

I would imagine a table like:

tblPOApprovals
POApprovalID (PK Autonumber)
POID (FK)
ApproverID (FK)
ApprovalDate

You also need

tblApprover
ApproverID (PK Autonumber)
EmployeeID (FK)
ApproverLevel

From here it can get complicated. The ApproverLevel field contains an order number that indicates who the first approver is etc. (Inactive approvers have their order set to Null)

You then need to check a query combining these 2 tables to see what the last approval level was and then select the next approver and send them an e-mail.
martinshear
Thanks. This looks like the design concept that would work.

You say it can get complicated? What do you mean

Yes all PO's are treated the same
Jeff B.
Sounds like a "work flow" process. Have you looked into any already-available, commercial applications (I recall some SharePoint pieces like this)?
ScottGem
QUOTE
You say it can get complicated? What do you mean


Because the proper table structure is only part of the picture. You will need to write code to do the checking and processing.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.