I need to make a data base in a wizard format for my franchisees to lodge service requests for a range of equipment that we sell. It will be broken up by 6 suppliers, and it will need to collect customer information, and then have a list of selectable components. After the fault is lodged, then it needs to e-mail the supplier the information, as well as an e-mail to the franchisee with a confimation and trackable job number. The supplier will need to log in and enter some sort of resolution. I as admin need to be able to run reports on average time or open jobs, like a list of jobs, and then how many days it took the supplier to close and comment on them. It must look Clean, and be easily editable if new products and suppliers come along. Direct MY SQL and a schema would be appriciated, as then I can write my own Crystal Reports.