Results 1 to 3 of 3

want Student Name to automatically show up after I type in the Student ID in my Meeting Information

  1. #1
    varu is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    4

    want Student Name to automatically show up after I type in the Student ID in my Meeting Information


    I have two tables. One has Student Information and the other has Meeting Information. The tables have a one-to-many relationship through Student ID.

    I want the name of the student (which is stored in the Student Information Table) to automatically fill in a column after I type the Student ID number in the Meeting Information table.


    How do I do this using queries?

  2. #2
    Bob Fitz is offline MS Community Contributor
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    1,657
    Sounds to me as though what you should be using is a main form and sub form.
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  3. #3
    AnandKhinvasara is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    31
    When you open up Meeting Information table, go on to create a new Lookup field by clicking on "Click to Add" in fields header. Follow the wizard that opens up and you would be through.

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

Similar Threads

  1. Student Information System Design
    By ghoughton in forum Database Design
    Replies: 3
    Last Post: 07-16-2014, 12:51 PM
  2. Student new to access
    By walter21907 in forum Access
    Replies: 6
    Last Post: 10-15-2013, 01:43 PM
  3. Student Database
    By jlc668 in forum Database Design
    Replies: 2
    Last Post: 10-09-2013, 02:26 PM
  4. Student Records
    By freekhenn in forum Access
    Replies: 1
    Last Post: 05-31-2013, 02:03 PM
  5. Student Information Systems
    By DrCreosote in forum Access
    Replies: 1
    Last Post: 09-29-2010, 05:33 PM

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
  •  
Tech Forums: Microsoft Office Forums