All I want to do is add a new index tag to the UPSystem table so there is no reference to a master table basically all I wanted was the equivalent of:

Index On Upper(Module+Name) Tag Name

However I could not see just how that might done using the Alter table .

Thanks,
Simon

>Simon, you need to reference the "master" table, something like:
>
>

>      Alter Table UPSystem Add Foreign Key Upper(Module+Name) Tag Name REFERENCES someOtherTable
>
>* optionally you can use a tag here if you do not want to use someOtherTable's PK by adding at the end of the previous command "tag {someOtherTable's existing tag}"
>
>