Question about fields

schlossy · Nov 4, 2005

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 · Nov 10, 2005

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 · Dec 26, 2005

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Question about fields

schlossy

Technical User

DeMann

Programmer

suesloan

Technical User

Similar threads

Part and Inventory Search

Sponsor