Relationship Database help. - Printable Version +- 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: Relationship Database help. (/showthread.php?tid=755)

Relationship Database help. - Worf - 03-06-2013 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: 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