Hello All, I am getting several requests to change the Company field in version 7.0.01 Ex. Joe's Computers is now changing it's name to Joseph's Computers.
Field ID 1000000001. When I search this field ID in ARutilities, it returns 417 references to that field. Has anyone come up with a way to change Company name and ensure it is propogated throughout the database? Other than a monster SQL script to update the field in all locations, I don't think this is possible. My current answer to this question is: Set Joe's computers to "Obsolete" and recreate as "Joseph's Computers". But then we lost historical reporting data, etc. Has anyone else encountered this? I just thought we couldn't possibly be the only company who has dealt with this situation. 7.0.01 Unpatched SQL Server 2005 Thanks, Jase _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
