Hi all, I'm trying to create a Foreign Key Constraint and I'm getting the following error:
violation of FOREIGN KEY constraint "FK_LOG_ITEM_LOG" on table "LOG_ITEM" Foreign key reference target does not exist However, both tables LOG (master) and LOG_ITEM (detail) are empty! Statement: ALTER TABLE LOG_ITEM ADD CONSTRAINT FK_LOG_ITEM_LOG FOREIGN KEY (LOGID) REFERENCES "LOG" (LOGID) ON DELETE CASCADE ON UPDATE NO ACTION Firebird version: WI-V6.3.0.26074 Firebird 2.5 Any clue? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!