Subdatasheets & Normalization?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
Click to expand...

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.
Click to expand...

That's right.
 
:

Definitely not. See my recent answer to your question in the table
design group (microsoft.public.access.tablesdbdesign)
Click to expand...
<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.
 
Back
Top