Edit Patient Fields

[Hersheydmd]

Strange Behavior when editing a Patient Field Name.

I noticed a typo and corrected "Periodontist" in the Edit Patient Field Def window.
Now, patients that previously had an entry, have two lines.
1) With the new name but the data box empty,
2) With the original name and the specialist name in the data box, but the line slightly greyed out.
I have to manually enter the data in the new "Periodontist" field.

If I run a query
Select * from patfielddef
The results only show the updated, correct field name, not the original name.
PatFieldDefNum.......FieldName.......FieldType.... PickList....ItemOrder....IsHidden
1.........................Periodontist.....0.............................1..............False
2.........................FAX #.............0.............................2..............True
3.........................Orthodontist....0.............................0,,,,,,,,,,,,,,False

So why doesn't the data that was in the field with the original spelling show it with the corrected spelling. The PatFieldDefNum is the same, shouldn't the data stay in the same field even as the field name changed.

If I run a query
Select * from patfield
The query shows results with both the original FieldName and the corrected FieldName, depending on whether or not I have manually updated that patient record.

Do I have to manually update each record?