I want to design a purchase requisition form for our intranet at work. The user will fill it in and click submit. It will then go to the supervisor will get another form where he/she will recommend and click submit. Thereafter it has to go to the finance department for approval. Users should be able to track progress on line.
Will appreciate help
Will appreciate help
Hi julie.steffers,
Where do you need help?
The first form should save the data to a database table with a 'status' indicator; then send an email to the Supervisor with a link to a second form including the new record id.
The second form can load the data from the table, then update the status when the form is submitted.
A CC listing (or possibly a third form) could show a list of requisitions with their status and links to let them be viewed/edited/deleted. This could be filtered by user to show either just the current user's entries, or all entries from a user group or all entries, . . .
Bob
Where do you need help?
The first form should save the data to a database table with a 'status' indicator; then send an email to the Supervisor with a link to a second form including the new record id.
The second form can load the data from the table, then update the status when the form is submitted.
A CC listing (or possibly a third form) could show a list of requisitions with their status and links to let them be viewed/edited/deleted. This could be filtered by user to show either just the current user's entries, or all entries from a user group or all entries, . . .
Bob
This topic is locked and no more replies can be posted.
