Hi, I'm having some problems with figuring out how to do this successfully without losing all the current values for each link.

I currently have a pull-down menu for 'Regions' which the user selects from when entering a new link. This list is an enum type field in the mysql database. What I want to do is change the values in the enum field, and at the same time also change the existing link values to match them.

What I've tried so far has successfully changed the enum values, but it's wiped out the link records if they don't match any of the new values.

Can anyone help?

Thanks.