Call all Database Gurus!
March 15, 2010 5:16 PM Subscribe
We have a process at work that requires multiple approval steps that we're trying to track.
posted by edjusted to Computers & Internet (11 answers total) 2 users marked this as a favorite
There are a potential 8000+ SKUs to track and each SKU needs to have each step accounted for (e.g. concept approval, art approval, pre-production sample approval, production sample approval). We have been tracking this with a spreadsheet but it's very cumbersome, and we've moved it to a MS Access db. The biggest problem with this is that it's not easily shareable everyone who needs a status check has to ask the person in charge of the DB instead of being able to look it up themselves. FWIW we're not a big company and probably no more than about 10 people ever need to look up this kind of info)
Can anyone give us suggestions on a better way to do this? Our criteria:
1. able to generate lists of items based on criteria (e.g. everything with item # prefix "X" that's not approved, anything that's been submitted for concept approval over 2 weeks ago, etc)
2. have some way for simple lookups/searches that can be performed by non-techie people (e.g. when was XYZ submitted for artwork approval? has the pre-production sample for ABC been approved, and if so, when?)
3. (this is important) the db should be relatively simple to create and maintain. We've looked at and think Filemaker might be a good solution.
4. here's a bonus: it would be ideal if an email was generated to certain people whenever that record was updated. e.g. if Joe was responsible for item XYZ, have an email sent to him any time XYZ's record is updated...likewise for Sally and item ABC)
We've considered Filemaker, CentralDesktop.com, and have even looked at doing some sort of Google spreadsheet. PHP/mysql is not out of the question if there was an easy way to create layouts and search result pages. As you can probably guess, we're not real strong with administrating DB's. Are we on the right track or is there something else we should be looking at?
(btw, why can't I ever get line feeds to work properly in Ask Mefi? is it just me?)