>Hi Aaron.

>>What is the best (or easiest) way to update a persistent relationship within a DBC in code? All I want to do is change the index used by one of the relationships.

>Check out the ALTER TABLE command.

>Doug

Thanks for pointing me in the right direction, but I'm still having some problems.

I have a "One to Many" relationship:
Table: ITEM
Index: itemcage
Related Table: INV
Related Index: itmcageuic

I want to change the relationship to use index BY_ITEM in ITEM (which already exists), but ALTER TABLE seems to want me to ADD/ALTER/DROP a column just to use the REFERENCES argument. Am I missing something? Any help would be appreciated.