I have to two tables like Dept in which fields are
DEPTID( PK )
Another table is EMP, the fields are
In this created a foreign key relation ship withEMP-DEPTID = DEPt-Deptid.
I want to insert some records to my custom table EMP.
There It should accept only emp-deptid value if it exists in Dept-deptid.
what statement I should write.
When I write " insert into zEMP values <workarea>.