Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

My parents own a small manufacturing business that needs a solution for tracking parts and information about those parts... for example, if someone called in with a serial number they need to know when it was made, who made it, when it was sold, etc... what do most small companies use for this? Is there software out there that helps with this, or should they just use a spreadsheet?

share|improve this question
    
I've been looking for something like this for a while myself. Had to build the skeleton of such a thing waaay back in a VB6 class (I know, shudder) - but haven't touched it since. –  warren Sep 13 '09 at 6:00
add comment

1 Answer

up vote 1 down vote accepted

Basically you need a database. Excel might do the job for a while, but it'll get messy and very large in very little time. I would recommend using a database. You could start with something like Access (which will let you make forms) or MySQL if you want a free DB, but I don't know what you can get for creating forms for MySQL. SQL Server would be my choice, and there is a free Express version for up to 5 users and reasonable size of data, with seamless upgrade to the full SQL Server should you ever need it.

Then the other option of course it to go on-line with something like Google docs.

There are so many options that I think you might get better answers if you can specify what inputs, how frequently, how many PCs are involved, whether they are all in one geographical location, how many types of lookup are there, and whether they want other reports from the system, such as finding all parts from a particular provider or from a specified batch.

share|improve this answer
    
Right now it's all in one geographical location, and probably will be for the next year or two at least. Basically I was wondering if there was any prepackaged software for this purpose... I'm considering writing them some software that will do it, but I've got a lot of stuff in the queue right now so I doubt I'd be able to do it in time. From the sounds of it I'll probably just let them do their thing with Excel for a while until I can get them some software to do it and import their spreadsheet into that. –  Max Schmeling Sep 13 '09 at 15:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.