Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unanswered: Some ideas about DB "sales"

    Hi , have any one ideas how to control a stock of products in two (or more) stockroom?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Stock(ProductID, StockRoom, Qty, aisle, shelf... )
    ??
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2007
    Posts
    2
    I am trying to make a db which has Product . A product can be stored in 1 or more different place (stockRoom). When i want to make a sale of a product then:
    First i want to know what is the current stock of product in each stocKRoom , Second i want to sale a Qty of product , from one of stockRooms.
    The Qty of product must be decrease the stock of StokRoom. (If i sale 2 product from "stockRoom1" the stock of this stockRoom must be decrease by 2)
    Last edited by jelis; 10-07-07 at 13:32.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •