missing data in calculation field

[Guy K.]

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

[Lee Smith]

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

[Guy K.]

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

[Lee Smith]

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

[Guy K.]

Original post edited & corrected.

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

[Lee Smith]

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

[Guy K.]

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!