pull data from one table and save it in another

B

Big Al

I need to be able to pull pricing information from a price list table and
store it under a new table with the customers quote information. we are in
the construction business and our prices change frequently, however once a
customer has been quoted his price is set and if our prices change before the
current customer is completed in our database his pricing information
changes. I need to make it permanent under their quote. any help will be
appreciated. I am trying to do it in a quote entry form but I am having no
luck. thanks again.
 
Top