Newbie: Merging fields into one?

[welby]

Hi,

just getting to grips with FM 7 - but have come stuck on the dumbest thing.

I have a field (Organisation) that is normally populated with Organisation titles. When it is blank I want to polulate it with three other seperate fields (Title) (FirstName) (Lastname) with spaces between each field.

I have tried many combinations but can't get it to work!

I tried this:

If IsEmpty GetField (Title) and GetField (Firstname) and GetField (Lastname)

I am frustrated as I know what I want to do but can't express it in terms that FM7 works with.

Thanks in advance.

[aaa]

Create Organization as Calculation field let it be YourField

YourField=Case(IsEMpty(Organization),Title&" "&FirstName&" "&LastName,Organization )

Instead Organization in Layout put Yourfield

[welby]

Wow, what a fast response!

Thank you.

I guess the moral of the story is to perform your complex calculations outside of the field.

Thanks again.