I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the word "Udate"
Why would that be?
CREATE TABLE Manufacture ( ManufactureID 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), Postalcode CHAR (5) NOT NULL, Areacode CHAR (3), Phonenumber CHAR (8) NOT NULL UNIQUE, CONSTRAINT ToyFK FOREIGN KEY (ToyID) REFERENCES Toy (ToyID) ON UPDATE CASCADE ON DELETE CASCADE );
MS2000, AS400, Access 2000
February 16, 2010 11:00 AM
February 16, 2010 6:22 PM