Relationship problem

[nipponlife]

hey guys i am building a database built around student class enrollment, gpa, and grades made and such on access 03

ok so i am stumped...i thought i had all my tables made and was gettin ready to get their relationships linked together and start drawing a report together...but i think my class_attend table is wrong...it wont let me enforce the referential integrity. please help guys....im so confused i have been workin on this for like 5 hours+ now...

thanks for ur time

heres a pic


[img=http://img218.imageshack.us/img218/1769/projectol7.jpg]

 

[Mido]

obviously i see that you r trying to make this relationship between the two StudentID feilds......what data types did u use for the StudentID feilds in both the tables ?????

 

[nipponlife]

im not really sure what you mean im really new to this...but i enjoy it...well i was enjoying it...until after 4 hours of work....nothing came together right lol...

if anyone has aim and can help me out real quik....my screenname is nipponlife86

honestly i think with the help of someone who knows what they are doing this could be resolved fairly quikly....

i think it has something to do with how i set up the primary key


PLZ HELP im goin crazy

 

[Mido]

I'm sure u set the StudentID in the students table as a primary key. Go to the table deisgn for the Students and for the class_attend tables and change the data types of the StudentID feilds in both the tables to "Text".
The way you set the primary key affects the type of the relationship (one to one, one to many,....etc).

 

[nipponlife]

ive managed to fix that lil problem but now i have another similar relationship problem

mido u have mail...and thanks so much for u help thus far

 

[theprez]

Just a thought, but your class attended should have a two keys. StudentID and ClassID. And now that I think about it, it probably needs 4 keys, just in case a student takes the same class more than once (i.e. they get an incomplete). So make the following fields Key fields in your class attend table: StudentID, ClassID, Semester, Year.