Split a table?

[dlab85]

Hey everyone,


I'm gonna get right into it; here are two tables I have in my database.
tblAccession
-Accession (PK)
-State
-Test Type


tblSamples
-Accession (FK)
-Sample
-Additional
-Cassette
-Tissue Type
-Comments
-Trim initials


-Trim date
-Section initials
-Section Date
-Control (FK from a third table)


For tblSamples, the fields:Accession, Sample, Additional, Cassette is the same for each accession and is entered when an Accession is logged in at the beginning of the process. The rest of the information (Tissue Type, Comments, etc.) is entered when various people completes those steps throughout the testing (fluctuating people and days). Should I have have the fluctuating information (tissue type, comments, etc.) as a separate table? With a one-to-one relationship? Would there be an advantage/disadvantage to splitting tblSamples into two different tables? Thanks for the input!

David

[alansidman]

Please read this: http://www.excelguru.ca/content.php?184

Crossposted at:http://www.excelforum.com/access-tab...t-a-table.html

[dlab85]

My apologies, I am trying to receive as thorough an answer as possible and figured accessforums would have more traffic. The previous post on excelforums has been closed. Thank you!