Hi Sue,

When you see the view within the DBC does the view have the renamed field names or does it display the original field names?

Best to open the database and type 'modify database'and find your view in order to do this.

If the view has the original field names then I believe you need to regenerate the view again and all should well.

In order to check what definition your view has in the dbc you can run gendbc.prg against your dbc and it will create a text file containing all your view definitions.

There doesn't appear to be anything wrong with your views select statement, it works fine for me.

What version of foxpro are you using and where is the data coming form?

Mark