Hi Pete ---
Create a one-time program for a view that goes field by field, tests for the existence of that field on the back-end (in case it's a calculated field as stated) and sets the Caption to the back-end caption? Seems to me that it wouldn't be too hard to do.
>Does anyone know a way of retrieving the underlying table field captions for use in a view, e.g. my base table has a field claim_ref with a caption of 'Claim Reference', but this not handed down to the view when it's used in a grid. I've tried various methods using dbgetprop() etc.. but without a great deal of success ( e.g. it bombs with calculated fields )
>Regards
>Pete Kane
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05