Reversed First and last names by accident
I have a very large database (FM 11). One person, by accident, had there first and last names reversed, and that person hasabout 50 dates of service.
John Smith 7/1/12
John Smith 7/2/12
and so on to change to:
Smith John 7/1/12
Smith John 7/2/12
and so on.
I guess I am looking for a find and replace option in FM.
Is there a way to reverse the order of the name without losing the dates of service already recorded?