can I use a form and pull data from one table and place it in anot

B

Big Al

I am needing to pull pricing information from a table and make it static with
current customer quote. Our pricing changes frequently however, after a quote
has been made I need the information to become static. Currently the way my
database is working if someone changes the pricing on the price table it
affects all customers. Not just new customers. I need to change this. any
help will be appreciated. Thanks in advanc. Big al
 
K

KARL DEWEY

You need to build a table that records the quotes. You should have --
QuoteID - number - autonumber
CustomerID - same datatype as your customer table
QuoteDate - datetime
ProductID - same datatype as your product table
Price - same datatype as your price table
Quoter - same datatype as your employee table
Comments - text - for any remarks relating to pricing such as 5 percent
discount due to volume - 10 percent add due to overnight - etc.
 
B

Big Al

I already have a table for the quotes. The price list is variables that are
used to calculate the total prices in a query based on what the customer is
wants. We are a construction company and most of our pricing is by square
feet. I need the prices variables to be pulled from the variables table and
then stored in the quote table so if the variables change after a quote or
contract has been issued then their prices will not be affected. Then my
query can perform the calcuatlions from the static numbers and not numbers
that may change. We have a lot of variables and I don't want our salespeople
to have to type them in on every quote we issue. Our quote table is quite
extensive since there are soooo many things you can change when building a
house. Also by having one table for the variables we only have to change them
once when we have a variable change. I know there must be a way to do this I
have just not figured it out.
 
Top