I have a restaurant client who has outsourced portions of their online ordering system (takeout and delivery) to three different companies. First, there is the ColdFusion application development, testing, deployment and maintenance provided by me. A second company supports the http network, where each of the 5 restaurants have Web servers, allowing food ordered online to be sent from the Web site to the correct restaurant. Third, there is the company that provides the point-of-sale system, which accepts the online orders off the Web, as well as orders from POS terminals in the restaurant, and prints tickets for the kitchen, cashier and a customer receipt. We need a trouble ticket system that allows anyone to open a trouble ticket, make assignments to individuals, automatically e-mail interested parties, update ticket status and close tickets. This must be simple enough for the customer to use, should be written in CF and use MS Access as the database backend. A lot of Googling has produced a lot of applications, but none written in CF. Any thoughts?