What's the error message? And what is the table metadata for both
tables?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> What is wrong with the following for adding a foreign key to a table?
>
> ALTER TABLE BOOK ADD CODING_ID INTEGER;
> ALTER TABLE BOOK ADD FOREIGN KEY (CODING_ID) REFERENCES CODING

(CODING_ID);

>
> Thanks,
> Stephen