Making a calender

[mhmmd.magdy]

I am a Mechanical Engineer working in a company that supply a medical
instruments and making a maintenance contract according to the
customer.

Actually my company is a small company, but it is going to be large.

I want to make a programm that make a scheduled maintenance table to
some customers and remembering me to produce a bill for every 3 months
for every customer.

Here is what i want to ask:
Is that possible to make this program by myself ?, and which programms
is more suitable for this job? or I have to hire a programmer.

 

[Allen Browne]

You will need some experience with relational database design to get this to
work - either that, or a strong desire to learn about how to create
databases, and a need to use that knowledge to create other databases in the
future.

You will need several tables here, including:
- tblClient (one record for each company you deal with)
- tblContract (one record for each contract you take out with a client.)

If a contract covers servicing of individual items, you will also need:
- tblContractDetail (a record for each item to be serviced in a contract.)
- tblItemType (one record for each kind of item)

You will then be able to create the servicing schedule for items in
contracts. This could be hard-coded, or you might like to have these created
on the fly as described here:
Recurring events - how to handle recurring events
at:
http://allenbrowne.com/AppRecur.html

There might also be another set of table to cover the scheduling of workers
to complete the servicing of items at clients, and recording of which
contract items were serviced when (so you have that history.)

Then there is the financial side (invoicing, payments received, etc) is a
whole other ball game.

There might also be an aspect of ordering parts in, tracking where they were
used and charging the client for them, and maintaining your inventory of
stock on hand.

Yes: it's likely to be a fairly sizeable project.