Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help with inventory DB

Discussion in 'Information Technology' started by TBoe, Nov 1, 2005.

Tags:
  1. TBoe

    TBoe
    Expand Collapse
    Guest

    The original request I had was to develop a database that would have a list
    of people and what items they have taken out of a loan closet. I have the
    Client_tbl and Item_tbl (a list of items in the loan closet) and a
    Item_Info_tbl (characteristics about the items. ie. Code, In, Out, Needs
    Repair, and File. I have the main form with the client info and a sub form
    with a dropdown box to choose the items and Code and checkboxes for In, Out,
    Needs Repair, and File. Now the person calls and requests an inventory DB.
    So she sent me the quantity info for each item. QUESTIONS: Can I revamp my
    existing DB to do this? If so I’m not sure how or where to start. Can I
    keep the check boxes and have the quantities decrease or increase depending
    if the box is checked? Or should I just start over and use the inventory
    template and revamp that to fit my needs. (This is in Access 97) Thanks
    much.
     
  2. Loading...


Share This Page