invoice solution question
I am creating an invoice solution and am trying to work out the best way to go around it.
I have four tables - Customers, Invoices, Line items and Products.
They are related by using primary and foreign keys as suggested by the Database pros (mark Osborne) video tutorials.
I want the user to be able to create a new customer from the "new customer" layout. There are a couple of buttons on this layout to perform the script "new order" or "new quote"
What I am having trouble with is:
When a quote is created, I would like the option for the user to create an order from this quote When the order is created, I would like an order number to be created as well.
THe order/quote fields must be editable.
When the order is converted to an invoice, I do not want the user to be able to edit it.
Can I use the same layout for quote/order/invoice? I would like the layout's background colour to change with each stage of the order process...
I hope this makes sense!