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
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