I have an Access Database with a table called tblStudentData which contains

among others a field called Skills_ID. I have a table called tblSkills which

have fields of Skills_ID, Student_ID, Skill1, Skill2, Skill3, Skill4.



The user takes a series of assessments that determine the value for Skill1

and so on.



I maintain tblStudentData.Student_ID in a session variable so when updating

tblSkills, I match Session("Student_ID") with tblSkills.Student_ID and then

update the fields.



BUT... tblStudentData.Skills_ID remains null. Everytime I need to access the

profile I have to create multiple recordsets to open, extract and close.



BTW, my relationship is set on Skills_ID in both tables.



Am I missing something about database design here? Is there an easier way?



Thanks,

Jon