I have couple of primitive ideas to do this job but I wanna see your suggestions guys . They might be much better than mine . I wanna design a database (Access XP) which holds items and subitems .For example:
Category One
-Item1
-Item2
-Item3
-Item4
Category Two
-Item1
-Item2
-Item3
-Item4
Category Three
-Item1
-Item2 (might include multiple subitems)
---Subitem2.1
---Subitem2.2
-Item3
-Item4
Category Four
-Item1
-Item2
-Item3
-Item4
Thanks in advance !
