Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Guidance Needed... (Access 2003)

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    Hey Everyone,
    Attached is a database that I am working on for inventory use here where I work. I have taken bits and pieces from other databases so I would not have to type too much.
    What I am trying for is, I will issue supplies to the staff, which I want to track, then I will also be ordering supplies for replacement. I just have this gut feeling that I am forgetting some sort of table. I also want to show a date when I issue items, which I think I have covered, but I also want to show a date when I requested replacement and when I received those items. I need to create a field/fomula based off of those two dates.
    As I ramble on, I know that I need to get my tables together before I can build my other items. I am not trying to put together anything too complicated. I am hoping to make this database dummy proof so other staff members can use it at there location.
    Thanks for everyones help and thanks for a great site "Woody".
    Mke
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Guidance Needed... (Access 2003)

    Do you want to link replacements to a specific earlier order (issue), or do you only want to know wether supplies were ordered as a replacement or not?
    If the former, you could add a number field ReplacementForID to tblIssue that contains the OrderID of the order it is a replacement for. If it's not a replacement, leave this field blank. You would create a query based on two instances of tblIssue, joined on OrderID vs ReplacementForID to link replacements to the original issue.
    If you only want to record whether an order is a replacement, you could use a yes/no field Replacement.

  3. #3
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Guidance Needed... (Access 2003)

    Hans,
    Thanks for the reply, but you have lost me. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    I am not following your comments from previous post.
    As far as replacement side of things, I am just wanting to track what is ordered from vendors and to add the quantity received into the inventory that is issued out. (Hope I am making since.)
    Thanks for any further help.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Guidance Needed... (Access 2003)

    This type of database is not my strong point, so my attempt was undoubtedly muddled. There are other Loungers who have much more experience with and knowledge of inventory databases, I hope that they can help you better.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Guidance Needed... (Access 2003)

    Hi, your mdb only has tables, perhaps if you include forms and explain what problems you have with them, we can be of better help.
    Inventory databases can get very complicated to manage. Here you can find an excellent hands-on treatise on how to handle them.

  6. #6
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Guidance Needed... (Access 2003)

    Hey Grovelli,
    I don't have anything else built. I am trying to get my tables build correctly so I can proceed with all the other stuff. I am actually trying to build a database based off a spreadsheet (attached). I need all the information on the spreadsheet included in the database.
    Thanks for the continued help.
    Attached Files Attached Files

Posting Permissions

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