Results 1 to 6 of 6
  1. #1
    shazi9b is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2013
    Posts
    5

    Question Need Help:Basic Inventory System

    Hello
    I am using MS Access 2007 to develop inventory system .I created 3 tables details are given below


    table 01: Products: (s.no , keyboard,mouse,agp,lcd)
    table 02 Purchase_Order (S.no , date, supplier ,product,quantity,rate,amount)
    table 03 Suppliers : (s.no , sup01 ,sup 02 , sup 03)
    Purchase order form created via table (purchase_order)
    i need help to select product which i purchased while entering data in form . how can i do it ?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,682
    Can each purchase order have more than one product? Need another table for order details. Then use form/subform arrangement.

    Might want to check out http://office.microsoft.com/en-us/te...010206882.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    shazi9b is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2013
    Posts
    5
    yes every purchase order contains more than one item like (lcd+agp).inventory templates doesnot fit at my requirements . i will try to develop different one .

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,682
    It might not fit but might get some ideas from it.

    Did you understand about another table and form/subform for data entry/edit?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    shazi9b is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2013
    Posts
    5
    i am atatching my database please review it
    Attached Files Attached Files

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,682
    My advice is the same. Need another table OrderDetails. It will have records to associate products with order number. The PurchaseOrder table will have the parent record with order number and date and supplier.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Basic Bridge Management System
    By daniel_l89 in forum Access
    Replies: 3
    Last Post: 09-05-2013, 11:47 AM
  2. Converting basic stock system from Excel to Access
    By Count Duckula in forum Database Design
    Replies: 1
    Last Post: 06-11-2013, 09:55 AM
  3. An inventory system
    By stew8908 in forum Access
    Replies: 3
    Last Post: 05-08-2012, 05:50 PM
  4. Inventory System
    By Rawb in forum Database Design
    Replies: 8
    Last Post: 01-05-2011, 07:26 AM
  5. Basic Quoting System
    By Travstar in forum Access
    Replies: 2
    Last Post: 12-12-2005, 09:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums