You can set the view captions with the foxpro-Function dbsetprop

e.g.

local lnCount
FOR lnCount = 1 to fcount(tcTableName)
=dbsetprop(tcViewName+"."+field(lnCount,tcTableName), ;
"FIELD", ;
"CAPTION", ;
dbgetprop(tcTableName+"."+field(lnCount,tcTableName), ;
"FIELD", ;
"CAPTION"))
ENDOFR

Regards

Franz

>When creating a local view, is there a way to retain the captions from the tables that the view is based on? Also, is there a way to use the field name rather than the caption in a browse window?
>
>TIA,
>
>Kris