>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, ;
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst