Thanks all and I appreciate the input.
To recap, I know of and have implemented a few ways to handle notes in a separate table. Some similar to what has been listed and I do not have any trouble doing that. But that was not my question. Alastair, Emmitt and Karen came closest to what I was inquiring..... The only reason I would use (not how to use) two tables in this case is that there (might?) be a higher risk of losing data using a NOTE data type in the main record, or that editing a Note data type might cause the entire record to be written to a different physical spot on the disk. (Thus eating up space over time) However editing the Note data type in the second table would do the same thing, so this might be a moot point. That leaves the higher risk of having a problem when retrieving a corrupt record as being the main consideration. I.E. it is better to lose just the note than the whole record. I will make my decision based upon that. Thanks again. -Bob
