01-03-13, 18:38 #1Registered User
- Join Date
- Jan 2013
Unanswered: Deduct a Quantity of an SKU from one db to the next Database...
currently we have some shipping software that has a mqsql database locally.There are filters on the program and when an item is shipped from our warehouse it goes into a filter "Shipped".We have a SKU and also quantity for the product.
Now we have an inventory program that also has a mqsql database,this has the same SKU as the shipping software database.what we hope to do is when an SKU is shipped in our software program(ie it Goes into the "Shipped" folder),it will deduct the quantity from the adjacent SKU in the inventory program database.
Note that the 2 databases are independent from each other but would like them to be in effect linked to each other.
Thanks in advance for any comments!!
01-04-13, 08:34 #2Grumpy old man (training)
Provided Answers: 11
- Join Date
- Sep 2006
- Surrey, UK
If you're working in MySQL, you probably want to try posing this question on the MySQL forum...10% of magic is knowing something that no-one else does. The rest is misdirection.
Beers earned: 2