Filemaker 6 - Need help joining two fields! Please help

[PromoPunch]

Hi everyone,

I have a FM database with around 90,000 entries. I want to add a new field and then combine it with another. For example:

Now I have:

John Doe

I want to add to all 90,000 records:

"Mr."

So now I would have:

"Mr. John Doe"

How would I easily go about doing this? So far I am able to create the new column and I created a script to loop through and add "Mr." to each field. Now I just need to find a way to merge it with the other column. I tried everything I can think of.

Thanks in advance for any help you may be able to offer.

Thanks!

[Jalz]

Hi PromoPunch,

What I would do is add 1 regular text field and make sure it appears on your layout. Lets call it Temp_field.

Second stage is to make sure you are in browse mode and the temp field is highlighted and then go to the top menu

Records -> Replace Field Contents -> Replace with calculated Result.

In the calculation if you type in

"Mr. " & YourFieldName and then click on OK and Replace.

That should do it.

Please make a backup before you do a replace!

Hope that helps