You should have a separate table for Work Orders. Your work order form
should be based on this table. This table design makes the price in the work
order table independent of the price in the products/services table. You can
leave the price auto fill in the work order form and if you need to change
it just move your cursor to the price field and edit it. The end resuly will
be no change to the product price in the product/services table and a
different product price in the work order table than is in the
product/services table.

Steve



"dvvog" wrote in message
...
I am using Access 2007. I have a database for my Products/Services
industry.
I have a table containing my products/services, as well as a Work Order
Form
that is linked to the Products/services table from which I can choose via
drop down the products that I am selling to that customer. The
Product/services table contains 3 fields; Product, Cost & Price. The Work
Order Form also contains those three fields, and when I choose a product
from
the drop down, the corresponding Price field fills in as well. Now,
sometimes
(after bargaining of course!) I want to change the price for that specific
work order without it affecting the main Products/services table, can
anyone
help?