Electronic Purchase Order With Authority Levels

S

Steve Whitnear

I need to create an Electronic Purchase Order database with different
authority levels for spend approval.
I want any user on a network to be able to create a new request and then
email a link to a budget holder for approval before it can be printed.
Please advise the best way to start or let me know where I can get a
template to start me off.
 
K

kingston via AccessMonster.com

You might start off by determining how many levels of approval are needed and
what each level of authorization (or denial) will do. I have a purchase
order database that is open for everyone to use and the initial data table is
located in a common folder on our network. Each request is assigned a unique
number for tracking purposes. When complete, a request is submitted for
approval and processing. I actually have to work with another database so
the data is copied into that system, but instead of moving the data (which is
a viable option), you could create a restricted table that tracks approvals
based on the request id. Then certain functions and forms would refer back
to this authorization table. If you are really concerned about security, put
the authorization table in a different database and generate connections to
it in code as needed. I don't think Access security allows for field level
control within the same table (at least not in Access2000) so you may have to
create multiple authorization tables for the different levels of approval.
HTH.
 
Top