Code library database help

T

Tim Cali

I am trying to build a code library database, and I need some advice on how
to go about this. The preliminary structure at first glance seems
straightforward. I have folders and code. For example, I might have a folder
of Date/Time and then a bunch of code related to that folder. So first off
here is what I see:

tblFolder
FolderID
FolderName

tblCode
FolderID
CodeID
Code

Ok, there's a problem with this. How do I assign one folder to another
folder? The above lends itself OK if I only go one level deep of folders,
however the realistic scenario is that I could have many levels.

So to put it more visually, I might have:

Excel Folder
Text Functions Folder
- Code snippet 1
- Code snippet 2
Access Folder
- Code snippet 3
ADO Folder
- Code snippet 4

etc.

So I would assign each code snippet to the folder just above it, but how do
I assign the folders themselves to other folders, in a way that allows
multiple levels?

Thanks for any ideas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top