>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao