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

Hi Guy,

You are referring to your field (last name) by two different names, Do you have two different fields for the last name, first name? (Note: your calculation is showing a "_" in "last_name" and then you later refer to the field as "last name" (no underscore)). If you have a double naming situation, prehaps the wrong field is being used in the calculation.

HTH

Lee

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

That's why I asked if you had two fields for each name.

Please copy the calculation directly out of the field and paste it in a calculation.

Lee

Original post edited & corrected.

No, there's no double name/double field situation.

Compare your Calculation to mine and you will notice a missplaced [color:"red"] " in yours.

Yours

company &"_"& first_name "&_"& last_name &"_"& phone

Mine

company & "_" & first_name & "_" & last_name & "_" & phone

HTH

Lee

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!