Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    39

    Inventory Question

    Suppose I have a table that stores my items with their quantity as a field. Should I create a separate field that stores how many are available? For example, when one is sold, should I update a field in the ITEMS table... or should this information just be dynamic... like...

    select.... (QTYInInventory - SumofQTYSold) as MyCurrentAmt...;

    This would be for a descent sized table.. say... 10,000 items?

    Thanks for any input.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: Inventory Question

    Originally posted by jestrada10103
    Suppose I have a table that stores my items with their quantity as a field. Should I create a separate field that stores how many are available? For example, when one is sold, should I update a field in the ITEMS table... or should this information just be dynamic... like...

    select.... (QTYInInventory - SumofQTYSold) as MyCurrentAmt...;

    This would be for a descent sized table.. say... 10,000 items?

    Thanks for any input.
    While I'm generally suspicious of summary values that can be derived by summing the underlying data, this is a value you should store (IMHO). The quantity available is a meaningful attribute of the stock item, and it would seem perverse to have to sum all the sales to date and subtract them from the original stock level to get the current stock level.

Posting Permissions

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