I need a small data base program to be used on an Apple MacBook Pro.
I need the program so that I can keep a record of all the fire extinguishers that I service for many companies they May have one fire extinguisher on there site or could run in to hundreds.
I will need a data bass for my clients sites to include servile fields that I can add notes etc, and be able to add more fields in necessary, I will need each site to have a unique code to link products to.
I will need to add products to each site that will need field for unique code for each product, size, type, install date, make, routing number, location, recharged date, recharge due, with the option of adding more fields.
I will need to print certificates after work has been carried out, this will be linked to an inspection sheet that I will print showing the work required for each site this will need to be linked by a unique code printed on the service sheet.
I must be able to amend any information as necessary and after each service is carried out I need to be able to update the site automatically by entering the date the work was carried out this will change the serviced carried out date and next service due and I will need to be able to select any product that has been recharged so it amends the dates.
I must be able to enter the frequency that servicing and recharging is carried out so when I print an inspection report it will show all product that are due within the service period.