I have inherited a form in the Accounts (we call it Companies) module.  There are 24 choices in a custom Pick List for "Company Type".  We would like to consolidate those down to 8.

Will Zoho Creator be my only option?  I'm an old-school programmer (COBOL, FORTRAN) and have been in software sales for over 10 years.  So I'm a little rusty at programming, and nervous that if I pull the trigger on a script I'll whack our entire CRM database.

Anyone have pointers on another way to atuomatically change OEM, OEM (oilfield), Equipment Manufacturer to one, single OEM entry?

Thanks,

Clay