concatenate fields

[freelancer]

Sorry for the newbie question,

How do I concatenate the fields last name and phone number in my client file to make a client ID field ?

Thanks for your help!

[freelancer]

Never mind, found the answer! Thanks anyways!

For those who have this problem : your type field should stay text and then you click on calculated value and write the fields you want to concatenate with the ampersand between them : Last_Name&Phone_number (in my case)

[falkaholic]

If your using that calculation field in a relation, you should do something like this:

LastName & " " & PhoneNumber

Since a last name and 10 digit phone number can be above 20 characters, and FileMaker doesn't work right when you use fields that have more then 20 characters *per word* in them (long story).

But if your not relating to it, you have nothing to worry about.