Lost data when changing field name
I am using version 6.0 on a mac OSX 10.4.
On our database, we had a field with the name "Conformation #"
I wanted to correct the spelling, so I went to "Define Fields" , highlighted "Conformation #" and replaced the o with an i in "Filed Name", then clicked "Save".
After I did that, the existing data in that field disappeared. I changed it back to the original spelling and still the data in that field was gone.
1) How do I get that data back
2) How do I make a simple spelling correction without the field being erased
vanelzak AT colorado.edu