when use designer,
I have a question regarding foreign key.
I have a choice between "can the foreign key be updated?"
if i select no, what 's sql equivalent ?
let's say i have dept,emp table.
dept have deptno 10 and 20
emp tom belongs to dept 10.
i have no problem to change tom's deptno from 10 to 20.
seem that there are some kind of foreign forbide tom change
his deptno, what's that?
[Edited by bxr556 on 05-31-2001 at 12:36 PM]