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 )