Customer/Purchase Orders Database

[Guest]

I have set up a data base with a Customer table, Items table, and Purchase
Order Table. Is there a way that once I set up a purchase order for an
individual customer, I can prevent the prices in the purchase order from
changing if I have to reprint the purchase order, but had already made
changes to an item in the items table?

 

[Smartin]

I have set up a data base with a Customer table, Items table, and Purchase
Order Table. Is there a way that once I set up a purchase order for an
individual customer, I can prevent the prices in the purchase order from
changing if I have to reprint the purchase order, but had already made
changes to an item in the items table?

Make a field for item price in the PO table and assign the value when
the PO is created.