forgot to add that i create a concentanted pk on EMP consisting of (EMPNO and ENAME) for testing purposes

steve