Results 1 to 2 of 2
  1. #1
    csdrip is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Posts
    1

    Freezer Warehouse Tracking Database

    Hello,
    I am a fairly new user to access and am looking for some assistance with my database.
    If you are interested in helping me, it would be greatly appreciated.



    Please contact me directly @ cdunn@georgiapecan.com

    1. I have two tables. The first is the main table showing (description, location, dateentered, dateremoved, productiondate, lotnumber, firstname, lastname) The second table is a list of products by description. On my form I have a combo box that references to the second table (list of products) which then logs that information into the first table. The problem is that it logs it as the ID number and not the description. How can I change the displayed data?

    2. I need to create a report that will show product by description, production date, or lot number. I want to maintain a list (behind the scenes) of all product which is loaded into my database, however, once product is "physically removed" from the warehouse I no longer want it to show up in the reports.

    Any help with this would be greatly appreciated.
    Thanks so much.
    CD

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    1) That is the normal behavior of a relational database. You store the ID value in related tables (that's what it's there for). You can use a query to join the two tables together to display the description on reports, etc.

    2) That would depend on your structure, but in general you'd base your report on a query with a criteria that excluded the products that have been removed.

    FYI I deleted your duplicate thread. Please don't post the same question twice.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Help with Tracking Database Form
    By KCC47 in forum Forms
    Replies: 46
    Last Post: 05-20-2013, 09:56 PM
  2. Material Tracking Database
    By bong in forum Programming
    Replies: 2
    Last Post: 08-19-2012, 07:54 PM
  3. Inventory/Asset tracking database.
    By russkris in forum Access
    Replies: 7
    Last Post: 04-26-2012, 02:27 PM
  4. Asset Tracking Database
    By wgroenewald in forum Access
    Replies: 3
    Last Post: 02-13-2012, 08:26 PM
  5. help with tracking within a database
    By martyn in forum Queries
    Replies: 0
    Last Post: 10-07-2009, 02:15 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
  •  
Other Forums: Microsoft Office Forums