Hey guys,
Hopefully I can do this I am not sure but my boss wants to add this as functionality to the database. I have a Request form that is filled out by a customer and has to be approved by two levels of people, "Level 1 Approver" and "Level 2 Approver". I would like to create a two buttons on the Request form that will first send an email to the approver to check the form. Since of security, I want to approvers to access the main menu of the data bases and click on a button that says "Approval Queue" and then the approver will open up a form that will ask them if they are level 2 or level 1 approver. Level 2 approver checks the form first, so he clicks on level 2, then somehow there will be information of all the forms that he has to approve, and then level 2 approver after opening up the Request forms and approving it, he click on the level 1 approver, and level 1 approver will go into the database and go to approval queue and click lvl 1 approver and open up the form. How do I get the button on the Request form to put information in the level 2 queue so the approver 2 knows what form to open as soon as he enters the database.
Hopefully it makes sense, Any help is appreciated!