0 Replies Latest reply on Feb 16, 2012 9:21 AM by Chris Turnbull

    Best Practice for Joining 2 Tables from the same data source - MSAccess

    Chris Turnbull

      Hi I have searched the forums but to no avail unless I am missing something.

       

      I have 2 Tables from 1 Databasse.

       

      tblStudentDetails - Contains StudentID, Name etc. - Primary Table

      tblStudentGradeTotals - which includes are a variety of Student Data which I want to link to the table above via StudentID.

       

      I have tried adding the tables in various ways and I keep getting the error messages below.

       

      Any help appreciated.

       

      Thanks

       

      Chris