Is this possible with SQL Server?

[Worf]

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

[Snake_eyes]

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

[Worf]

Thank you Snake_eyes, will have a look.