In my case I do'nt cascade on delete only on update so where is the problem?

TO make Thing simple let say my customer gives me a view of his employees table and i want to connect that view to my Rooms table using the field...

I'm afraid you are both mistaken?

look at the diagram :

A. if I'll change RoomNum in Room table it will update...

My Id's Are not Identityes And i cant make them Identityes.

U R right abut the delete cascade but I do need the update cscade!

any other ideas ?

Thanks your answear was very helpful!!