Re: Best practice to change a field from a character FD to dropdown.

[Ian Trimnell]

Title: Best practice to change a field from a character FD to dropdown.

** Dan Caissie wrote: ** Ok I have a character field that I need to change over to a dropdown. I need to do this with out losing the data for the character field, I guess I just looking for a best practice for this. AR 6.3 Thanks, Dan Caissie Dan, Depends whether you actually want to change the field Data Type to be an enumerated field or whether you just wish to change the Display Type to be 'Drop-Down List'.  The latter is useful as it makes users actually choose form an item on the attached menu rather than typing in something themselves.  Obviously you can't actually change the field Data Type to be 'Selection', you would have to create a new field and map the old data across to the new field. Hope this makes sense. Ian Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support & Information Team, Academic & Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741   web: http://www.open.ac.uk/ __20060125_______________________This posting was submitted with HTML in it___