Databases
Ok, I'm here again. I'd need STEP BY STEP guide how to bind three tables with foreign keys (that includes creating FK's, also). SQL server management studio crashes on opening file, so i need to do it in Visual Web Developer 2008. Oh, I also need to delete any keys except the primary ones from the tables, 'cause I took many tries to do that and I've maybee left something there. The three tables look like these:
Articles:
id
name
text
perex
dateAdded
categoryId
Categories:
name
id
Comments:
id
title
text
dateAdded
articleId
addedBy
I need to bind id from Categories, categoryId from Articles and articleId from Comments, so if i delete a category, it also deletes any articles in the category nd any comments that belong to them. Thanks.
Last edited by NOclipus; February 10th, 2009 at 05:22 PM..
|