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