I have a table with several FKs which is made up of two fields.
TMS aurelius does not recognize these CFs.
Can you suggest a solution for me?
(Firebird 2.59)
ALTER TABLE PA_CIES ADD CONSTRAINT FK_PACIES_CIEID_GL_CC_ESC_VTES FOREIGN KEY (ID_CIE,GL_CC_ESC_VENTES) REFERENCES GL_COMPTES(CIE_ID,COMPTE_GL) ON UPDATE CASCADE;
..
ALTER TABLE PA_CIES ADD CONSTRAINT FK_PACIES_CIEID_GL_CC_FRAISADM FOREIGN KEY (ID_CIE,GL_CC_FRAISADM) REFERENCES GL_COMPTES(CIE_ID,COMPTE_GL) ON UPDATE CASCADE;
..
ALTER TABLE PA_CIES ADD CONSTRAINT FK_PACIES_CIEID_GL_CC_M_CREANCE FOREIGN KEY (ID_CIE,GL_CC_M_CREANCES) REFERENCES GL_COMPTES(CIE_ID,COMPTE_GL) ON UPDATE CASCADE;
..