T
tvt
Hello,
I am trying to build a filing system that allows a user to enter and search
for documents. Here's where it gets complicated: there are multiple
documents to a file, there are multiple files to a category, there are
multiple categories to an item, and there are multiple items in a group (so
all one to many relationships). The file which holds the documents is also
assigned a location. This is how the layout looks:
A. Group1
1. Item1
1.1 Category1
1.1.1 File1 <---- location
1.1.1.1 Document1
2. Item 2
....
B. Group2
1. ........
Hope this makes things a little clearer. We're having trouble setting up
these tables. Any ideas?? Thanks!
I am trying to build a filing system that allows a user to enter and search
for documents. Here's where it gets complicated: there are multiple
documents to a file, there are multiple files to a category, there are
multiple categories to an item, and there are multiple items in a group (so
all one to many relationships). The file which holds the documents is also
assigned a location. This is how the layout looks:
A. Group1
1. Item1
1.1 Category1
1.1.1 File1 <---- location
1.1.1.1 Document1
2. Item 2
....
B. Group2
1. ........
Hope this makes things a little clearer. We're having trouble setting up
these tables. Any ideas?? Thanks!