Subdatasheets & Normalization?

[Guest]

1. Do subdatasheets assist in normalization or just make the data harder to
maintain?

2. In a drawer of 50 files 20 of the files contain other files (subfiles).
To create a normalized database, would you suggest I create a table for each
of the files that contains files? I have already created keys to identify
each record whether it be a "parent" file or a subfile. Creating new tables
for each file that contains files seems redundant and prohibitive for easy
data entry in the future.

Currently, I'm simply trying to convert a directory of files in Word to a
searchable database in Access, but I expect it to grow over time. Thus,
while keeping normalization in mind, I also hope that whatever I end up with
will be easy to update, add records to and query.

Thanks to everyone for their thoughts

 

[John Nurick]

1. Do subdatasheets assist in normalization or just make the data harder to
maintain?
Neither.

2. In a drawer of 50 files 20 of the files contain other files (subfiles).
To create a normalized database, would you suggest I create a table for each
of the files that contains files?

Definitely not. See my recent answer to your question in the table
design group (microsoft.public.access.tablesdbdesign)

I have already created keys to identify
each record whether it be a "parent" file or a subfile. Creating new tables
for each file that contains files seems redundant and prohibitive for easy
data entry in the future.

That's right.

 

[Guest]

:

Definitely not. See my recent answer to your question in the table
design group (microsoft.public.access.tablesdbdesign)

<snip>

John - I surfed around tablesdbdesign and searched for your posts, but
couldn't find this. Maybe I don't know enough to look for the right post . .
.. I'm sort of at the starting over stage too. Thanks.

 

[John Nurick]

The subject line is
Template for Legal File Library