Results 1 to 2 of 2

What is the best way to display my records?

  1. #1
    DesignGuy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Posts
    3

    What is the best way to display my records?

    Hello everyone,

    I'm working on a project for work with Access 2007, and I'm pretty unfamiliar with the program. Basically, I've created a database of approx. 500 asphalt mix designs. I created six tables with each containing a primary key named "DesiNumb". Then, I created a referencial integrity-enforced relationship between the DesiNumb primary key in Summary table with each DesiNumb primary key in each of the other tables. In other words, the primary key in my Summary table was connected to the primary key in each of the other tables.

    Then, I created a form that would let me input data into all of these tables. The design number (DesiNumb) primary key value was entered, and then all of the data for that design. All of the data was then entered automatically into their corrosponding tables with the unique record identifier (DesiNumb) for each. This was good!

    Now, I would like to come up with a way for the user to be able to simply enter in the design number (DesiNumb) and be able to see all the fields from all tables related to that record. Also, I would like for the user to be able to search for designs/records that have come from a particular location.

    Does anyone know what the best way to do this would be? I have approximatly 175 fields from 6 different tables I would like to be able to display at once from the user simply entering the design number.

    Any assistance is greatly appreciated.

    -DesignGuy

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,851
    Sounds like a structure similar to what I use for our lab data (which also includes asphalt mix designs among other procedures). A join of the subsidiary tables to the Summary table should be possible. Otherwise form/subforms arrangement is an option.

    Do you want to provide db for analysis?
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

Similar Threads

  1. query won't display records with no related records
    By James Brazill in forum Queries
    Replies: 1
    Last Post: 06-28-2011, 01:10 AM
  2. Replies: 7
    Last Post: 10-20-2010, 03:08 PM
  3. Display ALL records in a form?
    By evander in forum Forms
    Replies: 3
    Last Post: 07-15-2010, 06:59 AM
  4. Display all records
    By skwilliamson in forum Queries
    Replies: 3
    Last Post: 12-02-2009, 10:17 AM
  5. Display last five records only
    By premdasp in forum Queries
    Replies: 3
    Last Post: 11-18-2009, 09:53 AM

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