>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?
>
>If I change the command to:
>
>Alter Table UPSystem Add Unique Upper(Module+Name) Tag Name
>
>it works just fine.
>
>Regards,
>Simon

The whole command for FKs is:

ADD FOREIGN KEY [eExpression5] [FOR lExpression6] TAG TagName4
      REFERENCES TableName4 [TAG TagName4][COLLATE cCollateSequence]
      REFERENCES TableName2 [TAG TagName5]

So your command should be:

Alter Table UPSystem Add Foreign Key Upper(Module+Name) Tag Name;
      REFERENCES SomeOtherTable [TAG SomeTag]