Help Urgent please

[emad07306]

Hi everybody I really need help,this my class assignment,I tried hours fixing it I trying to relate the field name student Id from the table student to the table contract.Table student is the primary table and student id is the primary key in that table.Every time I create a relationship student Id between the two tables it gives me an error.I enforce referential integrity and cascade updated related field it gives me an error sayinh that data int table contract violates refrential integrity I have spend hours and days trying to fix it,couldnt do it.Please could someone help me here that's the reson I am here.I am attaching the database file,please help as soon as you guys can email me at emad07306 @yahoo.com
thank you

 

[CJ_London]

The reason is you have studentid's in the contract table which are not in the student table.

Haven't checked them all but certainly APP7509 and BAR7544 are not in the student table. Either delete them from the contract table or add them to the student table.

The error message actually explains it all - see attached

 

[Vassago]

These questions do not belong in the Watercooler. Please post in the correct location next time.

 

[Brianwarnock]

The reason is you have studentid's in the contract table which are not in the student table.

...

The error message actually explains it all - see attached

It kinda does doesn't it, how did you remain so polite?

Brian

 

[CJ_London]

I don't know - I sometimes wonder why some of the posts get posted!