+ Reply to Thread
Results 1 to 2 of 2

linking three tables

  1. #1
    Registered User
    Join Date
    04-27-2011
    Location
    Iringa, Tanzania
    MS-Off Ver
    Excel 2007
    Posts
    18

    linking three tables

    Hi expert!
    i have three tables one for Academic perfomance of the students, Bursor for paying school fees and the last for Admission. so i want to get the full details of a particular student, how do i do?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,893

    Re: linking three tables

    You will need to create a query and join the tables on common fields. Without the field names, primary keys and foreign keys, I cannot be more specific.

    In your query, use the relevant field names to extract the necessary information.

    This link may be helpful
    http://www.databasedev.co.uk/multipl...e_queries.html

    Alan
    Last edited by alansidman; 07-23-2011 at 08:22 AM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1