Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dsmith1000
Starting Member
6 Posts |
 Posted - 2001-09-20 : 10:00:56
|
| Hello,I am having a little trouble with a cascading delete. I want all the people that are signed up for a class in my "students" table to be deleted when the class is deleted from my "classes" table. I am using ASP to execute an Access query that will delete the old classes when they expire. The problem is that I can't build a relationship between the "ID" (autonumber) in the class table and the foreign key "classID" (text) in the students table to allow the cascading delete. It says the fields have to be of the same datatype for this link. Any suggestions? Appreciate any help,dave |
|
|
|
|
|
Cascading Delete