Guy K.

Hi, I have a contacts db. When viewing it online, the last_name field is empty. When viewing it in FM itself, there's nothing wrong. Many thanks

Right, I should have copy-pasted the formula from FM into the message, because this is another typo... Anyway, what I did last night: I recreated the layout and fields and reimported the data, and now it seems to work (except for a strange error when using the db via a browser, but that's for another thread). Thanks for your effort!

Original post edited & corrected. No, there's no double name/double field situation.

It should read both times "last_name"... ... Anyway, FM would have given me an error if I were typing the wrong field name in the formula window

One of our clients has a contacts database in FM. Earlier today they reported an error so I started to do some testing on the db. I created a calculation field Test = company &"_"& first_name "&_"& last_name &"_"& phone. In none of the records the first name and last name are displayed [color:"blue"] in this test field (e.g.: ACME___555-123456 instead of ACME_John_Doe_555-123456) . The company name, the underscore signs and the phone number are displayed correctly. In addition, the field "last[color:"blue"]_name" is always empty when using a browser (web companion). Anyone had the same problem before? Thx. Guy