ok thanks for the reply
the company is quite a large company. and there will be around 100-200 clients /computer details added daily.
as for the xml thing.
my client is being sent an email which contains data, the person he is recieveing it from can output it to xml for him.
he wants to be able to recieve the email, download the xml and then import the xml into the database. (to avoid manually inputting data, ie customer name, address, phone number, serials etc.)
i think the best way to go would be via php+mysql, and at a later date i would get someone to code a desktop app which will just pull the information from the database. but for now php would be fine.
__________________
Added after 47 minutes:
needs to Suits larger companies with an army of engineers, workshop or on-site repairs. Record all your clients, their units (things you repair), service details including parts, labour, travel etc and invoice them.
- Suitable for all maintenance and repair sectors; office machinery and computers, industrial equipment, motor vehicles, plant & machinery etc.
- Client database with full unit repair history and details of parts & labour charges and costs.
- Parts database to record unit costs and charges.
- Select the client, select the unit, add a service detailing the parts and labour and print an invoice (either as a tax document or as an input source to your separate accounts package).
- Set the unit service interval and each time a service is entered for that unit, the next service date is set automatically.
- Print a list of units due for service within a date range and other criteria so that you can canvass for appointments.
- Print a unit's full service history; what repairs and maintenance have been completed and all the notes and details about the unit and each service including all service costs and charges.
- So simple to use for single or multiple users to share.
- The database must be multi-user so you can share your information with all your colleagues.
- No user licences or repeat fees, or encoded files
- Fully customisable; you will have full access to the database & design objects so you can change or add anything you wish
just a few more things needed.