Results 1 to 3 of 3
  1. #1
    stevman22889 is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Pittsburgh, PA
    Posts
    3

    Pulling only certain data from tables.

    Hello,



    I am creating a database where you can choose from a list of statuses for each individual record. However, when one of the statuses (purchased) is selected, I would like it to prompt whoever is accessing the database to fill in some additional information (justification and cost). The way my database is set up now, the status_printer table is connected to the purchases table in a one to one relationship, connected by an autonumber ID. This allows me to choose a single record (the status_printer table is connected to the main printer table by serial) by serial number, but the cost center and justification are showing up for every record. Is there any way I can limit this so that that info will just pop up for a record marked as purchased?

    Visually:

    This is the setup of my relationships in the database. The table below is the status_printer table in this database, and whenever I choose to open a particular record, it shows the contents of the purchased table because of the way I have the relationships set up:


    My problem is, I want the information from the purchases table to ONLY show up when the status of the record is set to Purchased. I know it's probably going to involve an IIF function in either a Query or a Form, is there anyone out there who can help me with this issue? That would be greatly appreciated. Thanks so much!
    Last edited by stevman22889; 07-14-2010 at 01:47 PM. Reason: added pictures.

  2. #2
    stevman22889 is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Pittsburgh, PA
    Posts
    3
    Bump. Please check out the photos and see if you can help! I updated my post to include the screenshots so I hope this will help someone solve my issue.

  3. #3
    AccessThis is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    9
    So all you want to do is filter your table to show only purchases?

    Well a really simple way to do this for your own use is to click/highlight on the 'status_id' field and up at the top where the filter button is, you can click selection then choose equals 'purchased'

    and that should only display records that have their status_id set to purchase.

    You can build a query to do this permanently so you don't have to always press the buttons and just directly open the query to show what you want. Not sure if this is what you wanted, sorry!

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

Similar Threads

  1. Query not pulling at all
    By ricardo9211 in forum Queries
    Replies: 3
    Last Post: 02-20-2010, 04:13 AM
  2. Pulling value
    By Overdive in forum Forms
    Replies: 3
    Last Post: 11-08-2009, 03:07 PM
  3. Replies: 0
    Last Post: 07-27-2009, 07:51 AM
  4. Pulling out duplicates
    By FREEEEEEDOM in forum Access
    Replies: 1
    Last Post: 04-21-2009, 10:37 PM
  5. Pulling most recent data from child table
    By davidv43 in forum Access
    Replies: 0
    Last Post: 02-07-2009, 11:36 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