First off I Love PHPRunner so far.
Ok to my question. I have 3 tables that drill down
_MVendor >> _MReceive >> _MUsage
_MVendor is of course my vendors information
_MReceive is for receiving products into stock
_MUsage is for taking from _MReceive stock to be used for production orders.
I have my Receiving and Vendor working perfect but I am stumped trying to subtract from a different table so that I have an on going stock status.
So how would I be able to go to the Usage table and key in either - 800 and the Receiving Table will minus out and now show the new quantity?
Hope this all makes sense. I just purchased the software and I am probably overlooking something and there isnt much throught these forums so far.
Thanks in advance for the help <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5649&image=1&table=forumtopics' class='bbc_emoticon' alt=':P' />
