Brandon,
There are a number of ways to architect your application. Here is a basic structure for you.
The trick to keep your values constant is the Snapshot. Here is a screen shot of how to set that up in the Quote Items table. Under the Advanced Section of the Field is the Snapshot property.
How are you going to present the quote to the Customer? Quick Base does the calculations extremely well and will let you build your Order Management process after your Quotes. However it does not have a great presentation layer to get the sale and the $$$.
I strongly suggest you look at Juiced Tech and their Exact Forms Plus tool.
https://www.juicedtech.com/exact-forms-plusIt is very, very reasonably priced and will let you make lots of great documents for you to then use with Customers, Vendors, Operations....
Good luck with the app, hopefully this will help drive sales.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
