Hi. I am using MS Access 2010 and want to build a database for\norganizing my Code snippets and functions. I'd like to have different\ncategories and subcategories in a form where I can build a tree-view\nkontroll on the very left side of the form. Then, when clicking in the\ntree, I want the relevant function names og procedure names appear in\na table on the right side. Clicking that sub- or functionname, will\nmake a new modular form, with the actual code, Show.\n\nMy question is how do I build the tables.\n\nI started with two tables, one called tblCode with the following\nfields:\nID\nHeaderID\nCodeName\nCodeText\nAuthorName\n\nand another table I named tblHeadings;\nHeadingID\nHeading\n\nHow should I design the tables so that I can have a functioning tree\nwith headings like:\n\nExcel\n|____ Worksheet\n|____ Cell\n|____ Fonts\n|____ Functions\nOutlook\n|____ Mail\n|____ Task\n|____ Contact\n|____ Exporting/Importing\n|____ Appoiment\n\nAny help is very much appriciated. Thanx in advance!\n\nRegards\nJan T.