I would like to have a field which can easily be done with a calculation. I am trying to concatenate a husband first name & a spouse first_name & a Last_Name. Using a calculation field, it is easy to do this, but the result cannot be edited in the event of a change of marital status. Another problem is that some contacts are single and if I concatenate the contact first_name and there is no spouse first_name, it creates problems.
So how could I do an auto enter type of concatenation and have it ignore those contacts who do not have a spouse first name and still be editable should things change?
thanks in advance