If the CSRs ever get that verbose, we'll have more problems than a broken table! They're instructions, not specifications. So things that are different than the norm are noted.
Actually, I inherited the table like that and rarely is there a lot of data in all five note fields. I had been using it for years before I knew about the limit. Once I investigated a little further, I decided it wasn't an issue. Usually one note field has a few sentences and the others have a few words. Things like 'New Layout' or 'Increase dry time to 48 hours.' The longest total of all the note fields combined is about 1250 characters. I've been contemplating combining a couple of them into one field because they're not used frequently, but it's not something that hasn't made it to the top of the priority list. -----Original Message----- From: Albert Berry [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 1:04 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Note fields 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]
