Results 1 to 6 of 6

Thread: inventory table

  1. #1
    Join Date
    Mar 2010
    Posts
    5

    Unanswered: inventory table

    i am doing a data base for a rental company. i understand calculating stock is done by query, however where do i put in the starting stock? i know how to set up the fields and the rest of the relations I am unsure where i need to set the starting stock.
    i have attached my db for a look
    Attached Files Attached Files

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Haven't looked at the sample, but personally I would put in a transaction similar to a purchase to record the starting stock.
    Paul

  3. #3
    Join Date
    Mar 2010
    Posts
    5
    thx I will try that

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No problem; post back if you get stuck. Welcome to the site by the way.
    Paul

  5. #5
    Join Date
    Mar 2010
    Posts
    5
    i have posted the finished db. would you look at it and see if it makes sense? i have attached it
    Attached Files Attached Files

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    rar is not a common format here, and I don't have (and don't want) the software required to unzip it. Hopefully someone who has that software will take a look at the file.
    Paul

Posting Permissions

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