Violation of primay key

[greentopper]

Hi I am a first time user of sql server, and of late I am trying to build a database using sql server and I am starting to panic.

This is what I am trying to do: I am creating a db to register incoming students into a course.

1. I have two tables. Table A has all the fields for the student personal information in which I have Record # as the primary key. Table B has fields for the incoming student Educational Background (high school subject past) which has a Record # as the primary key.

2. I created a form using Table A and a subform using Table B which is linked via the Record #.

3. I am able to enter student personal information and one educational background information for a student, for example the school they attended, the year, subject pass and the grade.

However a student can have grades for more than one subject and there is where my problem is. The subform is continuous form since one student can have many subject past. When I enter information for a second subject for the same student in the subform I get " violation of primary key constraint 'PK_Education' Can not insert duplicate key in object 'Education' ".

How can I solve this problem?

What do I need to do or undo?

As I said before I am new to sql server and any help will be nice.

Thanks very very much.

[almaz]

You didn't partitioned your data correctly. As I understood you have:
1. Students
2. Subjects
3. Student grades on specific subjects.

Than you have to create three tables:
1. Student (StudentID, Name, ...) - will contain information about all students
2. Subjects (SubjectID, Name, ...) - will contain information about all subjects
3. Education (StudentID, SubjectID, Grade, DatePassed, ...) - will contain information about subjects passed by students.

This is a simple many-to-many relationship. It means that several students can pass a single subject, as well as one student can pass several subjects. This logic is accomplished using third table that handles relationship between Students and Subjects.