Results 1 to 2 of 2
  1. #1
    apmitch is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    17

    Training Tracker - how to show a list of completed training against a persons name.

    Dear All, I am new to Access and to this forum and a little long in the tooth! I am building an Access database to look after my peoples training records. I have a table which shows all the personal data, I have a second table which shows the completed modules per person. I then made a form for my peoples data, I then made a sub form for which I want to show a list of completed modules for that person. This is where I need a little help.



    Do I make a Query first to get the persons individual training records against his name? then from this make a new form, or do I when designing my table put a list of completes modules in the table, against the persons name. I am thinking the Query table but not sure, if a query table how do I do this, I have tried many many times without luck.

    Can some one please help an old man, thank you

  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
    52,822
    Master/Child links properties of subform container control will synchronize the related records of main form and subform.

    Main form bound to Personnel table and subform bound to Training table.

    Subform will show only the records that are related to the current record on main form.
    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. Generate Report that list current training course only
    By TheHarleygirl2005 in forum Reports
    Replies: 6
    Last Post: 09-27-2013, 12:19 PM
  2. Replies: 1
    Last Post: 09-24-2012, 07:09 PM
  3. staff training data base, training
    By SAJAN in forum Forms
    Replies: 1
    Last Post: 09-22-2012, 05:09 AM
  4. Training Tracker Table Relationships
    By Desstro in forum Database Design
    Replies: 3
    Last Post: 11-30-2010, 10:15 AM
  5. VBA Training
    By nywi6100 in forum Access
    Replies: 1
    Last Post: 10-26-2006, 10:24 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