access adp subform connected to sql 2005
i am having problems using access 2003 as the front end connected to sql 2005 express as the back end when trying to create forms with subforms. Pulling up the main table retrieves everything in the linked table and not by the linked ID items.
name, address, etc
coursetitle, time, etc
when i setup a main form for StudentTable and then create a subform for ClassTable I want the forms to retrieve the student name and all the classes they are enrolled in. When I try to do this, I get the student name but in the subform it is retrieving all the classes in the ClassTable. I can't get it to bind to the studentID.