Richard,
I am thinking of updating my unit cost as a part of the receiving of the purchase order.  Can't I just write the update SQL code into the build event of the receive PO button thus updating cost to current cost from the vendor? I would link the inventory file with the order detail file on inventory id since the orderdetail table would automatically have the matching inventoryid and vendorid as part of it's generation.  I could also make sure that the date of receipt was after the last update date to make sure that I have the latest vendor cost...Does all this sound viable to you?

---

Reply from Richard Rost:

Sure... just be aware that the vendor could change his price between the time you order and the time the parts are actually received... but aside from that I see no reason why this wouldn't work.