Equipment Management

[webfoo]

Hey Everyone,

I am trying to develop a equipment management web ap. This ap involves having records for each piece of equipment, signing that equipment to people for events, and then returning that equipment. Records must be kept of each person, each equipment, and each event. It will run on UniServer on a USB drive, rather than on a website because this will mostly be used where there is no web access.

I have halfway hacked something together in PHP/MySQL, but I know it's not fantastic. Are there any pre-canned solutions that might accomplish this?

[webfoo]

Or any suggestions to make it better.

[bill]

You could use something as simple as an Excel spreadsheet with some macros to do that. There may be some working templates out there already that accomplish what you want.

[piatkow]

Start with some classic analysis techniques such as entity relationship modelling.
Once you are clear on WHAT information you are handling and WHAT you need to do with it then it is pretty straightforward to determine the HOW.