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