Look at afields() and alter table. However, it is better to track and control the table structures before your app runs. A good time to do that is when an update is installed. The update can go out and modify the tables as necessary - add those fields which were added in development but don't exist on the client's system yet. I recommend you look at SDT (Stonefield Development Tools) for this. It will automate it for you and handling the table structures modifcations required during updates at client sites.

http://www.stonefield.com/sdt.html

Or did I miss something and you are using a different backend than VFP tables?



>Terry,
>
>At the moment a message appears 'field phrase is missing' if the control source of a column in a grid is assigned a field name and the field name has been changed or does not exist within the table.
>
>
>Is there any way of capturing the incorrect field name and then replacing it with a correct value.
>
>Thanks