one note field and a ref#
> Thanks for your input > Bob C. > > > > > "MikeB" <[EMAIL PROTECTED]> > Sent by: [email protected] > 05/04/2005 10:46 AM > Please respond to > [email protected] > > > To > [email protected] (RBG7-L Mailing List) > cc > > Subject > [RBG7-L] - Re: Note fields > > > > > > > I use one table with a RefNo column to link... > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Wednesday, May 04, 2005 8:27 AM > Subject: [RBG7-L] - Note fields > > >> Hi all, >> I am back to creating a medical dictation system that has many > categories >> for a single dictation. >> For example, some of the fields would be "Current Problem", "Past >> History", "Physical Exam", "Plan", etc, etc. >> >> All of these fields have a variable amount of data, from a sentence to >> paragraphs. I would like to use a combination of note and varchar > fields >> in a table for these fields, maybe 8 or 10. Is this going to be a good >> thing to do??? >> >> I heve never put more than one note field in a table, and in the past > have >> tried to isolate the field into a different table in case of pointer >> corruption, but in this case.....is this a safe thing to do?? Lately I >> have not had any corruption issues. Is there a better way to do this? >> Opinions all welcome! >> Thanks, >> Bob C > > >
