>Hi everybody,
>
>I'm trying to write a CREATE TABLE statement which would create referential integrity as well. I'm trying syntax from the Help file, but it gives me "syntax error".
>
>Do you know the proper syntax here?
>

>CREATE TABLE (m.lcPath + "Data\DealerOpts1.DBF") ;
>				(OptsId I AUTOINC PRIMARY KEY, OptionID I REFERENCES DealerOptions TAG OptionID,
>				 MakeID I REFERENCES Manufacturers TAG MakeID, ;
>				 ModelID I REFERENCES Models TAG ModelID, ;
>				 Retail N(10, 2), Cost N(10, 2), CostLine N(10, 2), Type C(12), StdOption L )

Naomi,
You are forgot ; at the end of the line

>				(OptsId I AUTOINC PRIMARY KEY, OptionID I REFERENCES DealerOptions TAG OptionID, ;