I have a SQL-server database and the interface is done with access. Now I have a problem with deleting a record. I have linked tables and the program won't allow deleting a record that has information with information in theese tables. How can I delete all the related information also? The problem might be more of a SQL-server type of question. I'm not that familiar with that and I haven't even done the database myself I just gave spesifications of what I need in the database.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deleting records
- Thread starter Raksaus
- Start date
Hi
The "easy" way to do this is to set a referential integrity relationship between the two tables and set the cascade delete option to true. Not sure how you do this with an SQL table
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
The "easy" way to do this is to set a referential integrity relationship between the two tables and set the cascade delete option to true. Not sure how you do this with an SQL table
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question