hai everybody,
i have one problem regrading check table.
my req is i created two table
1 emp table in that i created two fields
empno - primary key
empname
2 dept table in that created three fields
depno primary key
empno - here it is foriegn key
depname
i maintened entres in emp table it is ok
but when i maintained entries in dept table it should be llike this depno and
and check table entry should be allowed,but when i entered other then check table entries it is accepting it is going to save.but it should not be like that
can any body help me to solve this issue.