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.