03-06-2013, 09:05 AM
Hi
I'm trying to create a database in SQL Server 2012 and Visual Studio 2010.
I have created 3 tables:
Categories - Table 1
Sub-Categories - Table 2
Scripts - Table 3
The Table looks like this:
![[Image: serverexplorer.jpg]](http://img209.imageshack.us/img209/447/serverexplorer.jpg)
As you can see, SubCategoryT has a relationship with CategoriesT & ScriptsT has a relationship with SubCategoryT.
What i can't figure out is what part of the tables do i use as i can't seem to get it to work?.
How i want it to work is like this.
The user creates a Category, lets say 'Electronics' and a Sub-Category 'Motherboard'. All the information entered into table 'ScriptsT' is stored under 'Electronic - Motherboard'. and so on.
Many Thanks for any help.
Regards
Tony
I'm trying to create a database in SQL Server 2012 and Visual Studio 2010.
I have created 3 tables:
Categories - Table 1
Sub-Categories - Table 2
Scripts - Table 3
The Table looks like this:
![[Image: serverexplorer.jpg]](http://imageshack.us/photo/my-images/209/serverexplorer.jpg/)
As you can see, SubCategoryT has a relationship with CategoriesT & ScriptsT has a relationship with SubCategoryT.
What i can't figure out is what part of the tables do i use as i can't seem to get it to work?.
How i want it to work is like this.
The user creates a Category, lets say 'Electronics' and a Sub-Category 'Motherboard'. All the information entered into table 'ScriptsT' is stored under 'Electronic - Motherboard'. and so on.
Many Thanks for any help.
Regards
Tony