I am trying to create a FKEY relationship between 2 tables JOB and JOBDEPARTMENT. D_NAME is the pkey of JOBDEPARTMENT and J_DEPARTMENT is the FKEY FIELD IN JOB.
When trying to execute:
alter table JOB
add constraint FK_JOB_1
foreign key (J_DEPARTMENT)
references JOB_DEPARTMENT(D_NAME)
on delete CASCADE
on update CASCADE
I get the following errors in IBExpert:
This operation is not defined for system tables.
unsuccessful metadata update.
object JOB_DEPARTMENT is in use .