Knowing a great deal is not the same as being smart; intelligence is not information alone but also judgement, the manner in which information is coordinated and used.
I have used your invoicing template and adapted it for my service business. I have created a button on the main menu to open the customer form to add a new customer. Once the customer is added, how can I make the appointments button (in your database the orders button) open a new appointment (in your dattabase new order) update the customer field to the new customer I have just inputed so I can add appointment details?