I have a form with related tables that i use to figure the cost of some custom products that we build. Works excellent. Now I need to fill in a quote form with not only those items but also price products "on the fly" and the quote form has to hold the current price from the custom item at the time the quote is saved, even if I change the custom items pricing later (I must hold the price for my customer that I quoted on a given day). What I have done is to use a combo box to lookup values for the custom items using the PK from the custom items table. Then I am using Dlookup to populate the fields on the quote form and using a bound text box to write the values to the quote table. Seems like it is working, I just need to iron out what events to use to trigger the write to quote table or update to quote table if I change something before saving the quote for printing. Does this seem like the right way to go about this? And yes I know I am stepping away from normalization but that is how it has to be unless someone has another way to keep the quote table from being updated if I don't want it updated.
I hope this makes sense.
Thanks for any comments
I hope this makes sense.
Thanks for any comments