I am not sure if that is the right operation here but I have a field called
"number" that stores the address number of a property and a field called
"name" that stores the name of the street. I want to merge them together in
another field but am unsure how that works.

I am sure it is simple but I am very new to FM 8.5 so I am just feeling my
way around.

Thanks to all
AJ

firecop1 <ajb5540 (AT) optonline (DOT) net> wrote:

If you only want to display the number and the name, you can put them on
the layout using the "insert" menu, or just type them like this:
<<fieldname>>.

In order to merge them, you will have to use a calc field with text
result. The calculation may look like this:
number & " " & name


--
http://clk.ch

In article <1hzuz82.e3wqiw1jv1w4kN%clk (AT) freesurf (DOT) ch>
clk (AT) freesurf (DOT) ch(Christoph Kaufmann) wrote:

in one swoop:
Choose whichever field you want as destination.

Under menu Records, select Replace Field Contents.

Select the "Replace with Calculated Result" option.

Enter the calculation:

YourNumberField & " " & YourStreetNameField

Click OK, etc.

Done.

Matt