This is not an OOTB field, right? I presume you added it to BaseElement then. I presume the enum in q is a "standard" enum (ie 0,1,2,3, ...) rather than an enum which has the values declared (1000, 2000, etc). The latter is always a bit easier to handle. The fastest and easiest is with SQL if you have no need for auditing and the like. You must do it carefully !! esp. in the right order. If you added 5 and there are 10 already, change 9 -> 10, 8->9, etc There was also a free tool that purported to do this. chgselection? or something of that nature. Or, you could use Meta-Update and simply effect the changes with the enum labels: DRP Tier = @LookUp, LkupDRP, $Src, DRP Tier$ [LkupDRP] enum2 = enum5 enum3 = enum6 etc. The free trial license will be enough to complete this job. Email me off-list for further info. Cheers Ben Chernys
Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:[email protected]> Ben.Chernys _AT_ softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kelly Logan Sent: June 15, 2010 12:05 AM To: [email protected] Subject: Mass modify of enumerated alias values ** Hello All, Our organization needs to use a different structure for the enumerated field 'DRP Tier' on the asset forms. Fortunately, these are all derived from the field on the BMC.CORE:BMC_BaseElement form, so changing the selection value on that form changes the selection value on the 140+ other join forms that are based on it. What it doesn't do is update the alias values, so even the display of the value is incorrect. Is there a way to mass modify the alias values of all of these join forms? I'm thinking the key is in the fields_dispprop form prop(Short/Long) fields, but I don't know how to decipher these. Kelly Logan _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
