>The documentation seems to say that I can set a 1 to 1 relationship between tables with the command "Alter Table table1 references table2". However this gives me a syntax error, as does "alter table table1 references table2 tag mytag". Can anyone tell me what the syntax of the command to establish a 1 to 1 relationship between 2 tables with primary keys in a DBC? Thanks.

looks like it would be something like:

ALTER TABLE Table1 ADD FOREIGN KEY KeyExpression TAG TagName1 REFERENCES Table2 TAG TagName2

just from scratching my head over the docs...