Hi,
Im trying to make a database that will have 3 main tables:
Customer
Maintenance
CallLog
The Customer table will just have main information about the clients i.e Name, Address etc.
The Maintenance table will have a new record set up for each cutomer that will have details regarding what type of support they will be offerd, the main field being "number of call outs logged".
And the CallLog table will get new records added whenever they want to log a callout.
What i want is for every time there is a call logged for a customer the "number of call outs logged" record in the Maintenance table to be reduced.
Would someone be able to give me any clues on how to do this?
Thanks
Im trying to make a database that will have 3 main tables:
Customer
Maintenance
CallLog
The Customer table will just have main information about the clients i.e Name, Address etc.
The Maintenance table will have a new record set up for each cutomer that will have details regarding what type of support they will be offerd, the main field being "number of call outs logged".
And the CallLog table will get new records added whenever they want to log a callout.
What i want is for every time there is a call logged for a customer the "number of call outs logged" record in the Maintenance table to be reduced.
Would someone be able to give me any clues on how to do this?
Thanks