Dawn, you do have a potential problem. If the note fields plus key ever add up to more than the 4k row size limit, you will have a broken table. Just a FYI. As long as the note fields are never filled completely, you are ok.
--- Dawn Oakes <[EMAIL PROTECTED]> wrote: > Bob, > > I have one table with 5 note fields representing departmental > instructions for our shop orders. Links to our shop orders table with > the job# as the PK / FK. Works great. > > Dawn > > _____ > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 04, 2005 11:15 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Note fields > > > > Mike, > That was the plan, and I have used that technique in the past when > linking a single note field to another table full of text and ddate > fields. My real worry is the multiple note fields in one table. > Or......do I have multiple tables with 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 > > > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
