>thanks i have tried using the ALTER TABLE command and it works fine but reading through the help it says that you can use ALTER TABLE to add an index. i am having trouble can you please help. the code i am using is:
>
>alter table worklist add foreign key workcat tag workcat
>
>thanks
>
>daryl

Foreign keys must reference another table's primary key. You need to specify the REFERENCES table name Tag index name clause at the end of you command.

HTH.