Looking for advice on a database my client has requested to be made.
They basically create keychains and coffee mugs with custom logos/pictures/names/etc on them. I need to create a database that shows current activites with client catagories.
Within the client catagories I need lists of all current projects in progress.
Within the works in progress I need text input areas as well as set information. Example:
( Current Activity )
| | |
| | |
(Company 1) (Comany 2) (Company 3)
| | |
(1) (2) (3) (1) (2) (3) (4) (1) (2)
Each project file within the company would require this:
Art Name: _________
(Description of Project)
Date Received
Due Date
Artist
Artist Notes:
That's just a small idea of it. Within that everyone with access to the project files must have the option to create new project names, descriptions, etc so that the project managers can keep track of what is going on, who is working on it and when it might be finished as well as priorities/catagories/etc.
This database is basically to keep everyone involved in the project and keep up to date daily/weekly information as to where everything stands.
Along with this I need to be able to print the individual project files and email them as well.
Any ideas on what route to take on this?
Thanks in advance!
Start Free Trial
