Getting a record approved

[wadey]

I'm VERY new to access so please bare with me.



I've created a nice simple database for purchase orders to use within my company. I've designed it so I have a field with the person's name who created the record in it, I've got a field where I have a tick box for "approval" and also a drop down box with names I have from a contacts table. The creator field links to a separate table from contacts and all have been imported from my outlook address book.

Is there anyway I can set it up so only the person who's name is in the drop box can approve the record, either by going in or preferrably via an e-mail request?

[alcoool]

There are more then one way to do what you want:

1. set usel level security on your data base (compicated)
2. create a back end to your data base and multiple front end mde files (one for every tipe of user)

for the second solition do this

1 create a database that contains only the tables (back end)
2 create another mdb file with the forms and querys needed for person how creates the record (you need to link the table from the back end) (front end 1)
3 create mdb file with querrys and forms for the person that aproves (you need to link tables from back end) (front end 2)
4 make mde files for front end files and ghive them to the users
5 acces works over a networs by sharing a folder (so you can link tables over a network)

for more info pls e-mail at ale_vento@yahoo.com