Do I calculate or lookup?

[cr3ation]

Please forgive my igorance. I'm still teaching myself.

I'm taking an old mailing list and trying to integrate it with a new one. The new list has a "FirstName" field but the old one doesn't, however the old one DOES have a "Saluation" field containing the info I need to copy.

I tried to define a calculation for the "FirstName" field:

FirstName=

Salutation

But this only seems to work when I'm entering in new records. How can I make it go through the existing records and fill in this new field?

Any ideas?

[-Queue-]

Find all records, put your cursor in a non-calculation field on your layout, select Records -> Replace Field Contents, 'replace with calculated result', and type the name of the currently selected field into the calculation. Click OK, then Replace. This will force existing records with a blank FirstName field to update using the auto-enter calc.

[Leader]

Sheesh, Q, good one.

It's so easy to forget the simple solutions.