Â
Hey Matthew, you have no idea how grateful I am that you replied.Â
Â
I added a screen shot of my database relationship.
Â
The language is french, let me try to explain.
Â
Â
Yellow : Clients
- Client table, with client information
- Client notes, related to client. Shown as a portal in the client table so that I can add multiple notes per client.
Â
Green : Estimates
-(Dark Green) This is the estimate section. It's linked to clients, and contains the date of estimate and calculations for taxes to give me the Total price.
-Light Green (Soumission_details), It is the lineItem table, contains the quantity, the lookup of the price of the product in the product table and calculates the subtotal. Shows in the estimate section through a portal. The table occurrences linked to this table (in orange) let me use dropdowns to narrow from Category,Make,Model,ID,Price (Not sure if it is the right way to do)
Â
Gray: Contracts
Same fields as Estimates for Contracts
Same fields as estimate_details for contract_details
Â
Heres what I'm looking to achieve. Through the Estimate Section, I want to select accepted for the status, and have the program copy the fields from Estimates to contracts and Estimates_details to contracts_details.
Contracts differ from estimates because they will cause an inventory move and $$$$ will be used to calculate my sales and profits. I need to be able to modify the contracts without altering the original estimate.
Â
Eventually I'll have a table for inventory, quantity in (Purchases) and out (sales) that will be linked to products.
Â
Sorry if I'm not clear enough, let me know if you don't understand something and I'll try to explain better.Â