Several of the fields in my database have dates associated with them- (I know it was a terrible idea to begin with) but the field is called eg. data06, data07,data08. When a new year rolls around, the operator needs to physically change the name of the oldest field: data06 to data09.

Is there anyway to do this programmatically. IE is there a way to have VFP modify an actual field name using code.

thanks for any suggestions - (that don't involve me re-engineering database structure that date back 12 years.)

k