I have done this before but for some reason it is not working and I can't figure out why! I'm importing records from an old database into a new one using FM Pro 10 Advance. The old DB did not have an address table and the new one does. I have created a field that lets one choose which address type it is, i.e. Main, Billing, Shipping, Install. I'm importing records from the old DB in groups. So the first set I import the addresses that I know are the "main" ones. After I import that group I want to do a find and replace of the currently empty address type field and set it as "Main". I will do the same with each new group import, just changing the address type field to the appropriate selection.

I select the field in the layout go to the Find and Replace, set a "=" in the find field and "Main" in the replace field, tell it to search across all records for that field only and replace. It still leaves a blank field. I've changed the field from a drop down value list to edit field, and made sure there is no other restrictions, like a strict value type or no modifications but it still doesn't work. What am I missing?

I select the field in the layout go to the Find and Replace...

And that's the problem.

Wrong command.

You want "Replace Field Contents"

Try using these two steps in succession:

Perform Find[]

Replace Field Contents[]

instead of the single Perform Find/Replace[] step - which may sound similar, but isn't.

I just "learned"! Thanks so much, I didn't even know that existed!