2 Replies Latest reply on Jun 28, 2010 1:14 PM by HarvJNep2n

    concatenating from fields including value lists

    HarvJNep2n

      Title

      concatenating from fields including value lists

      Post

      Mac OS 10.6

      Beginning User

      FM 11

       

       

      I have the following fields:

      name_salutation (validated by value list including Mr., Mrs., Dr., etc.)

      name_first

      name_nick

      name_last

      name_full

       

      All of the above are text fields. 

      I have set up the name_full field to concatenate the other fields using an auto-enter calculation in this way:

      name_salutation & " " & name_first & " " & """" & name_nick & """" & " " & name_last

       

      The field operated correctly except it doesn't import the name_salutation field contents. In name_full I should see a result like this:

      Mr. Michael "Mike" Smith

      and instead I get a result like this:

      Michael "Mike" Smith

       

      I have checked the parameters of the salutation field many times, making certain the name is correct in the calculation dialog box. The only difference between the fields which ARE concatenating correctly and the one which isn't is that the one that isn't happens to be validated by value list. If it changes things, the value list is a conditional value list (there are other categories of salutations, depending upon whether the customer is military, involving ranks unique to their branch). 

       

      Please tell me how to concatenate text including source data from a value list.

       

      Thanks,

      Bryan Cheney