I have started to read the book by Cecelia L. Allison and Neal A Berkowitz on SQL for Microsoft Access. and there is a syntex listed below that has been giving me a problem. I get an error with the word UNIQUE. So I removed it from the statement and then I get an error with the ON section at the end of the statements. Why is that. I am using MS Access 2000.
CREATE TABLE Manufacturers ( ManufacturersID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, Address CHAR (50) NOT NULL, City CHAR (20) NOT NULL, State CHAR (2) NOT NULL, Postalcode CHAR (5) NOT NULL, Areacode CHAR (3) NOT NULL, Phonenumber CHAR (8) NOT NULL, CONSTRAINT ToyFk FOREIGN KEY (ToyID) REFERENCES Toys (ToyID) ON UPDATE CASCADE ON DELETE CASCADE );
February 2, 2010 1:56 PM
February 3, 2010 5:33 PM