Newbie value list question

[DoctorB]

I am working on a medical record db in FM 5.5. I want to check positive responses to a long list of symptoms as they are asked and then have only the checked items appear in a separate text field in paragraph form. I would like to add the results of other lists to the same text field. For example: “runny nose, stuffy nose, sneezing”, picked from a list of 20 nasal symptom choices becomes: “The patient reports runny nose, stuffy nose, and sneezing, lasting two weeks. The "two weeks" coming from a separate check list. I can create a field for every symptom and then add the ones checked “yes”, or I can pick each symptom from a table but these solutions seem wasteful. Any help would be much appreciated.

[Raybaudi]

Hi

you need only a calculation field ( result text )

Substitute ( yourCheckList , "¶" , ", " )& ", lasting" & yourSeparateCheckList