I have not read whole help but

snip
CREATE TABLE | DBF TableName1 [NAME LongTableName] [FREE]
[CODEPAGE = nCodePage]
( FieldName1 FieldType [( nFieldWidth [, nPrecision] )] [NULL | NOT NULL]
[CHECK lExpression1 [ERROR cMessageText1]]
[AUTOINC [NEXTVALUE NextValue [STEP StepValue]]] [DEFAULT eExpression1]
[PRIMARY KEY | UNIQUE [COLLATE cCollateSequence]]
[REFERENCES TableName2 [TAG TagName1]] [NOCPTRANS]
[, FieldName2 ... ]
[, PRIMARY KEY eExpression2 TAG TagName2 |, UNIQUE eExpression3 TAG TagName3
[COLLATE cCollateSequence]]
[, FOREIGN KEY eExpression4 TAG TagName4 [NODUP]
[COLLATE cCollateSequence]
REFERENCES TableName3 [TAG TagName5]] [, CHECK lExpression2 [ERROR cMessageText2]] )
| FROM ARRAY ArrayName
snap

or do you focus on the SQL Server? Then I'm wrong but your snippet looks like VFP

Are you shure the DBC is in focus?

I have done it in extra commands (until I stopped with relationship by DBC but this is an other problem) all the time ...

Lutz
>>O.K.
>>
>>The hlep states it should work.
>It does not!
>
>
>>
>>The primary key of the target of the relationship is set?
>>What error?
>
>
>syntax error
>
>
>>>Peter