problems creating one to one relationship

[alexthefourth]

i have two tables, student and transcript.




a student can have only one transcript and a transcript belongs to only one student.
im having trouble creating this relationship in access 2013. is there a way to create this?


also, can there be a one to one relationship between two different primary keys?


these are my tables

Transcript
------------
transcriptID(PK)
courseID
grade
studentID

Student
---------
studentID(PK)
major
fName
lName
GPA

[June7]

Both keys cannot be autonumber.

Why bother with two tables if this is truly a 1-to-1 relationship? However, I have doubts it is. Each student can have many courses and each course can associate with many students. This is a many-to-many relationship and Transcript is junction table that associates students with courses.

Shouldn't GPA be calculated when needed and not saved in table?

[alexthefourth]

thank you, that makes sense.

[alexthefourth]

I have one more problem course has prereqs(courses that must be taken before a specific course) and coreqs(courses that must be taken along with a specific course)

i guess this would be a unary relationship so one course can have many courses. but how can this be modeled with relationships?

[June7]

This is like a family tree database. Which is, IMHO, a difficult model (manufacturing is another). I do have something similar.

I have laboratory tests that have companion tests. I have a table of all tests and then another table that associates a 'master' test with companion tests. Some companion tests can be associated with multiple masters. Some of the 'companion' tests can be selected independently of the master. The master tests always call for the companions. Because test data has to be saved into separate tables for each test involved (even the companion tests), I have lots of code to manage this when a sample is logged in and tests are selected.

Possibly you need two tables for the two types of associations.

[alexthefourth]

what do you have in the second table? and whats the relationship between the master test and second test table?