PC Review


Reply
Thread Tools Rate Thread

Update and Delete cascade

 
 
=?Utf-8?B?c2NvdHQ4NDEwNw==?=
Guest
Posts: n/a
 
      21st Feb 2007
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

--
scott
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cascade Delete and Update Issue Linda RQ Microsoft Access Database Table Design 4 7th Nov 2007 04:15 PM
Relationships - Cascade Update and Delete Vayse Microsoft Access ADP SQL Server 0 16th Aug 2006 06:00 PM
How to enforce cascade update/delete? =?Utf-8?B?Q2hyaXMgQnVybmV0dGU=?= Microsoft Access 3 2nd Nov 2005 10:56 PM
Cascade Update & Delete =?Utf-8?B?S2FyZW4=?= Microsoft Access Database Table Design 10 15th Sep 2005 07:29 PM
cascade update/delete question Jamie Microsoft Access Form Coding 3 24th Jul 2004 05:50 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:07 PM.