I have a database with a calculation field. The calculation asks for data to be brough in from a related DB. After the data is brought in (text) is there a way for a user to add more text to the field. I do not want the data to change the related field, but to only add additional data to the users comments.

The calculation reads:Comment= Case(CPP_1_3="Unsatisfactory",Domains::KOC_U,CPP_1_3="DEVELOPING",

Domains::KOC_D,CPP_1_3="PROFICIENT",Domains::KOC_P,CPP_1_3="DISTINGUIST",

Domains::KOC_DI)

When one of the four words (Unsatisfactory, developing, Etc.) is chosen, text is placed into the field "Comment" I want the user to be able to add more information to the comment box, but I do not want the KOC fields changed in the relational DB.

Thanks

Lester

PS - When I try to enter data into the field, I get the message, This field is not modifiable

Lester

Hello lesterd,

One solution would be to define your field to 'auto enter by calculation' using the same formula.

Auto entry calcs can be subsequently edited.

Another oprion would be to create an additional text field and appeand it you your calc formula, then stack the fields (with the calc in front and with the 'allow entry into field' option turned off) Then users can click into the text field and enter what they will - and the result will appear appended to the calc when they exit.

There are still other options, but the above might give you a few ideas to work with for starters.