Yes, I get it. But no can seem to answer my question about putting a current price into a quote and not having it change. EVER! Unless I want to update it. I’m sure there is a way. I just don’t know anything other than dlookup. Also I don’t know how to get the calculated data on the quote form as a price since it is not the same structure and the tables the calculations are based on. Or maybe I’m just to inexperienced to write the query correctly. It takes a lot of calculations and 3 tables to get the calculated sale price of a custom made product. But I do have it on a form. Just not sure how to put it into a field on the quote form and keep it there. If you have any suggestions I would love to hear them. Thanks again for all the help.The best part of not storing calculated values in a table is they'll never be wrong, and you won't need to update them, ever.
Let's think about it another way, do you keep personal information about your clients in a separate table? You know, their names and addresses in say a Customers table? If so, do you assign or use a Customer ID? If so, do you then use or store the Customer ID in the Quotes table? Or, do you copy the customer names and addresses from the Customer table into the Quotes table?