> > >What is the code for adding a foreign key to a table, just a simple
> foreign
> > >key from one table to another?
> >
> > You need to use ALTER TABLE, once the table is created or add the

foreign

> > key in the CREATE TABLE statement.
>
> What is the correct syntax for defining a simple foreign key in the CREATE
> TABLE statement?

Check the Language Reference or Data Definition Guide for InterBase.

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."