Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mass change field name in formulas?

Status
Not open for further replies.

mrtroy

Technical User
Jan 28, 2003
23
US
I use a field in 36 different formulas. Is it possible to mass change the field name in the formulas without having to open each one up, change the field and save?
 
mrtroy,

This is possible if:

a. you change the name of the field in the database - then open the report - go to the Database menu -> and choose verify database -> click yes when it prompts you to the fact the table has changed, and all formulas will be updated.

or

b. Use a meta layer such as a business view and rename the field there - then do a Set Datasource location and map the table fields to the Business View Fields.

Other than that the answer is no.

Cheers,
paulmarr
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top