David,
Yes, the REFERENCES clause is required.
< UPDATE >
Hmmm...I'm not sure exactly what it does in the DBC...
< /UPDATE >
What is wrong with using INDEX ON command?
>I need to clarify this post:
>
>1) I am working with a FREE TABLE. I want to add an index tag using alter table.
>
>2) I am not sure this accomplishes what I want - I want to just create a tag. I don't need to set up a relationship betwen tables.
>
>3)I see an example in the help that says:
>
>ALTER TABLE orders;
> ADD FOREIGN KEY cust_id TAG cust_id REFERENCES customer
>
>I guess the references clause is required, and sets up a relationship between the two tables? When I add the references clause - I get the error that non-dbc tables are not supported.
>
>>Instead of opening my table inventory, and then executing:
>>
>>index on kit tag kit
< snip >
Steve Gibson