>Can anybody pls tell me how to automatically transfer Captions from base table to view ??

I would say you can write a utility to open all your views with NODATA...

Use cursorgetprop to get the list of table.fields in the view...

Then, loop throught the fields getting the caption for the table.field and putting it into the view.

Stonefield Database Toolkit also simplifies this for you, if you use there DataExplorer, properties you set on the table can be cascaded to views.

BOb