>>I have an application I made for a friend's school. I need to add a field to a table, but I'm wondering what is the correct way to do this without disturbing the data in his database. <<
Check out
Stonefield Database Toolkit. It will handle this ( and more for you ) quite easily. Personally, if you are doing pure VFP development, you cannot affort to be without it.