AnsweredAssumed Answered

PO

Question asked by malibux14x on May 12, 2014
Latest reply on May 13, 2014 by philmodjunk

Title

PO & Inventory control

Post

     i feel like this is a basic question but for the life of me i cant figure out a way to do it.

     i have one database with multiple tables.  one is a Purchase Order (PO) that has fields paired with the product table.  that pairing works perfectly.  but what i would like is to have the inventory i have entered into the PRODUCT table go up and down in accordance to ordered entered into the POs.

     again i feel like this should be easy but just having a brain fart.  any direction would be appreciated.

     thanks!

Attachments

  • Attachment
    DB286.3 KB

Outcomes