FYI ..here is my setup for the field in the database
Replace Field contents is the wrong step to use here. It updates the specified field for ALL records in the current found set, not just the current record. Use Set Field instead of Replace Field Contents.
I knew it was something simple...