I have a table names Customers with the field CustID as primary key.

I then issued this DDL query to create another table - Orders:


CREATE TABLE Orders (OrderId INTEGER, CustId INTEGER, Qty Integer, CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId) REFERENCES Customers ON UPDATE CASCADE

When I execute the query a "Syntax error in CONSTRAINT clause" is returned and when i click ok, the DELETE clause if highlighted.

I am using MS-Access 2007.

The same error is trigered when I use the On UPDATE clause. The UPDATE if highlighted.

Many thanks everybody with help on this.



Vie
@Abuja