+- BP Forums (https://bpforums.info)
+-- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=55)
+--- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=56)
+---- Forum: VB.NET (Visual Basic 2010/2008) (https://bpforums.info/forumdisplay.php?fid=8)
+----- Forum: Programming Help (https://bpforums.info/forumdisplay.php?fid=9)
+----- Thread: Is this possible with SQL Server? (/showthread.php?tid=749)
Is this possible with SQL Server? - Worf - 02-23-2013
Hi.
I want to creat a database with catagories and sub-Catagories and want to know if it is possible to do the following?
I'll try and explain what i want to do the best i can.
In my database i want catagories and sub-catagories.
Lets say the user added a catagory called 'Electrical' and a sub-catagory called 'Fan' another catagory call 'Vegitation' and a sub-catagory called 'Bushes'.
Anything to do with 'Electrical'- 'Fan' goes under this and anything to do with 'Vegitation' 'Bushes' goes under this.
So i would end up with something like this?
Catagory: Sub-Catagory: Information:
Electrical - Fan Fan information
Electrical - Kettle Kettle info
Vegitation - Bushes Bushes info
Vegitation - Trees Tree info
So if i want to store anything Electrical will go under Electrical and any thing to do with Vegitation will go under Vegitation. ect, ect.
I am using VB.Net 2012 and have created my table.
Many thanks for you help.
Regards
Worf
Re: Is this possible with SQL Server? - Snake_eyes - 02-24-2013
Wahat you explained is very posible and its called Table Relationship.I cannot explain it in words cuz it will take me all day to type but just watch this tutorial and you will understand how it works
http://www.youtube.com/watch?v=8Ar12QnUwhs
http://www.youtube.com/watch?v=uKVJOPdgloA
Re: Is this possible with SQL Server? - Worf - 02-25-2013
Thank you Snake_eyes, will have a look.