Hello Listers, ARS 7.1 MS SQL2005 Does anyone have any insight in just when it is best to choose a selection field over a character field? The character field would have a menu and the display type would be Drop-Down List.
I am asking because time and again I get customers would "never" want to change the value in the menu/selection field BUT always ask for and addition, removal, reorder or change of a value. Anymore I am inclined to only use character fields with menus and reserve the selection fields for things like "Inactive/Active", "No/Yes", "False/True", etc. Is there a big performance hit using menus? Is it even an issue anymore? Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

