My companies order process goes like this:
Create Quote for Customer --->
Recieve and Confirm Purchase Order From Customer --->
Generate Work Order for our production department --->
Generate Invoice for Customer.
I would like to relate all the different types of Orders("Quote", "Work Order", and "Invoice"), but still keep them all in one table("ORDERS").
How would I have to configure my tables and table occurrences to accomplish this?