>Hi
>
>I have been testing the Alter Table Command and it worked fine when I tried to create a candidate index tag but fails when I try to create a Foreign Key tag.
>
>I get a syntax error with following:
>
>Alter Table UPSystem Add Foreign Key Upper(Module+Name) Tag Name
>
>Where is the syntax error?

You're missing the REFERENCES part of the ADD FOREIGN KEY clause that indicates what table it's a foreign key to.

Tamar