Database for creating and tracking work orders

By jimmy ·
I have a small computer repair shop, and I have just hired a 2nd tech. Up until I hired this new person, I have just used a simple check-in sheet with my notes on it, when working on computers for individuals. I have a different system that I use for my business clients, and it is all linked into my Quickbooks software for Billing etc..

The new tech is working solely on personal computers for residential clients. I would like to find (I am really too busy to sit down and create my own, unless I just have to, cause I haven't done much DB stuff in about 7 years) a database, or database driven setup that we can use to checkin the computers when they arrive, which will create a unique work order number for each computer, then we can enter our work history, and then later, we will be able to search the history, if a person brings a computer back a year down the road, we can see if it is the same problem, or something different.

I am able to 'build my own' if I need, but I was going to check here first, so that I didn't have to re-invent the wheel if one is already available.

I am trying to keep this as low budget as possible, so FREE is wonderful, but if the best solution is a product that is available for sale, I would consider that, but low budget is a big consideration.

At some point in the future, I would possibly want to link this DB to my website, so that on-site work could also be entered from the clients' home. But that is

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by Choppit In reply to Database for creating and ...

Take a look at some of the projects over at Sourceforge. I only performed a quick search and read the summary but this sounds something like what you're looking for;

Collapse -

Exactly what I was looking for

by jimmy In reply to Sourceforge

Thanks for the assistance. I had actually already downloaded MyITCRM before your post, but I had not done anything except download it after a brief Google search at about 4:00 a.m. then I immediately went home and to bed, forgetting all about the program I had downloaded, until your post. Thank you for the referral, after I set it up, it is working like a dream. There are 1 or 2 items that I wish were slightly different for my unique setup, and I will search the forums to see if anyone else has addressed the same requests before I worry too much more about the minor 'wish list' items, because 98% + is EXACTLY what I was wanting.

Related Discussions

Related Forums