Question about fields

[schlossy]

I am making a program for guests to a wedding. I have 3 field, salution, first and last name. I want to create another field called place card and have the information from (salution, frist and last name) to automatically go into the placecard field. Is there a way to do that? I know you experts probably know.
Thanks in advance
Cari

 

[DeMann]

yeah, go into field definitions, for your new field, go into options, and create a creation formula for the field, combining the other fields.

_______________
[cN]

 

[suesloan]

Another solution would be to define a "calculated" type field and put the formula into there using the Combine() function to add the three fields into one dynamically. That way, you can change one of the fields and instantly see the change in this calc field.


PlaceCard = Combine(salutation,' ',firstname,' ',lastname)

Replace the field names in my example with your own.

Sue Sloan