Update and Delete cascade

S

scott84107

When I try to run this create table query in Access 2003 I get a syntax error
on the constraint. It works if I take out the cascade lines.

create table Salesperson (
Salesperson_ID COUNTER CONSTRAINT SalespersonPK PRIMARY KEY,
Salesperson_Store_Key long NOT NULL,
Salesperson_Last_Name text (20) NOT NULL,
Salesperson_First_Name text (15) NOT NULL,
Salesperson_Social_Security_Number text(9),
CONSTRAINT Unique1 UNIQUE (Salesperson_Social_Security_Number),
CONSTRAINT Relation1 FOREIGN KEY (Salesperson_Store_Key) REFERENCES Store
(Store_ID)
ON UPDATE CASCADE
ON DELETE CASCADE)
I appreciate any help I can get with this. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top