May 7, 2007 at 10:05 am
I'm developing an app where the users want to be able to edit their multiline text boxes as rich text. The app is for the creative department of a company and they want to be able to keep copious notes on all the different phases of developing new products.
Developing the Rtb editor is done, and I'm storing the notes as text. There are 12 notes fields associated with the individual items, so I've created a table with just the notes, and links back to the item table. So far so good (i think). I've just got a nagging suspicion that there might be a better way to do this....
Any suggestions?
Michael
May 8, 2007 at 6:57 am
If I read your post correctly:
Table 1: Item Information
Table 2: Item Identifier + 12 Notes Fields (Note1, Note2, ... Note12)
Why do you need 12 different notes fields in Table 2? I am assuming that there are 12 notes fields to correspond to the 12 different phases of development. Couldn't you just have a field to indicate phase? Thus:
Table 2: Item Identifier + Phase + Notes Field
Norene Malaney
May 8, 2007 at 8:35 am
Norene,
In fact that is what I have...
ItemID + notetype + note
I guess I was really worried about the possible size of the data transfer. But we're not a bank doing a gazillion trans a day. There are going to be a handful of people working on this, and I doubt they're going to write war and peace in all twelve possible fields
Thanks!
Michael
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply