I want to create a form, that a requester submits to their manager for approval, and then this manager needs to submit the same form to director level for final approval.

How do I have 3 submit buttons (one for requester, one for manager, one for director) on the form, that is only visible to that respective user? For example, once the requester has hit the submit button, the form then is routed to the manager, who will then have a submit button, and so forth.

Hi Stacey

I hope that you found your adobe dreamweaver course very helpful.

The method that I would use to do what you want to do would be to:
1) Create a form for the requester, the requester submits the form, this then enters all the details into the database, and emails the manager notifying them of the request.
2) The manager opens up a web page that extracts all the information from the database (i.e the information the requester submitted). When the manager clicks submit, the data is submitted into the database and an email is sent to the director.
3) The director opens up a web page that extracts all the information from the database (i.e the information submitted by the manager).

If you need more information or a different solution let me know.

Hope this helps
David

Stacey,

You'd really need a database attached to your web site for this to work effectively.

In the database table, you could have a field called Status of ENUM type, with possible values such as 'draft', 'approved' and 'complete'.

You would also need to have log-ins and permissions for each user. Best to use SET type for this: 'requester', 'manager', 'director'.

Knowing which user is logged in (using sessions and cookies) would then enable you to have the correct button shown on the form.

Once a button has been pushed, the item's Status field would change to the next ENUM value.

To achieve this, you'll need to know a programming language like PHP, ASP, any server side scripting language. If this sounds way too complicated, you may need to contract in a web developer.

I hope this information has been useful. Let me know if you require any more information.

Regards, Rich

Thanks Rich. Your response makes a lot of sense, and I can picture it all now. I will try and develop something myself (I have a very good ASP.Net book in VB) that should be able to help me, but the connection to a database will be which I will need to look into further. Appreciate your help.

Stacey