Results 1 to 5 of 5
  1. #1
    haitham_ebeido is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Jan 2018
    Posts
    2

    Inventory App, a Table Automation update Case

    Hi Everyone,

    My Case is about Auto Updating a Table that is not in the form I want to use.. Like Below:

    First of all.. I have a table for Storage... (Inventory Application), which refers to Product ,Quantity ,Ex Date , Reference Inventory(FK) from Inventory Table Indicating which Inventory this storage is...

    And I Have 2 Tables for Invoice, Invoice Header and the other is Invoice Lines,
    Header Contains Inv No. , Supplier, Date of Invoice and Received Date,
    Lines Contains Line Product ,Quantity ,Exp Date and Reference Inv No. (FK) Indicating that this line for what Invoice..



    The Case Exactly is.. I've a Form for Invoice Header containing a Subform of Invoice Lines, (Connected to the Tables)
    and what I'm trying to do is to Auto Update Storage table (which is not connected to form, but surely my Database has the Required Relationships)
    and Auto Update Storage table with Lines, I Mean to add Records and also to Increase Quantity of Products if other Fields Match..

    I'm not into Macros or VBA as well.. but can anyone provide me with a good solution?

    And Thanks

    Haitham Ebeido

    Underlined : Tables
    Bold : Columns

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Saving calculated data, especially aggregate data, is usually a bad idea.

    Ideally, enter transactions of product received/used and calculate balance from the raw data when needed.

    Review http://allenbrowne.com/AppInventory.html
    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
    haitham_ebeido is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Jan 2018
    Posts
    2
    I know..

    but I’m trying to find a smoother solution to non-experienced users to Access..

    and try to keep them away from the need to access the raw data

    But thanks for reply

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You may get some ideas from this free youtube video on Stock Management and/or these free data models from database answers org
    http://databaseanswers.org/data_mode..._pos/index.htm
    http://databaseanswers.org/data_mode...inventory_mgt/

    The Allen Browne reference by June7 is an often referenced source of Inventory ideas.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why do users even need to be aware of the db structure? Users should only interact with forms and reports built by developer (you) to meet needs. They should not go anywhere near tables and queries, especially if they don't understand relational database principles.

    User enters criteria into controls on form and clicks button on form to run a report. Report opens. How data gets to the report is unimportant to user.
    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. Change text case from upper to proper case
    By s.nolan in forum Access
    Replies: 1
    Last Post: 12-02-2015, 10:56 AM
  2. Replies: 3
    Last Post: 04-28-2014, 03:17 PM
  3. Replies: 2
    Last Post: 02-12-2013, 07:27 PM
  4. Replies: 3
    Last Post: 09-26-2012, 01:39 PM
  5. Case or Switch in an update statement
    By allenjasonbrown@gmail.com in forum Queries
    Replies: 7
    Last Post: 11-17-2010, 01:49 AM

Tags for this Thread

Posting Permissions

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