Thanks a lot Hari Although it seems you understood my problem correctly but to make things clear let me give you a picture of problem with some data.
My table has following two Columns 1--RuleType (Enum) 2--RuleValue (String) RuleType is an Enum with following two Elements 1--Designation 2--Gender On the form When user selects Designation in RuleType, RuleValue should allow a custom Lookup to select one Designation from Designations table. I can do this. When user selects Gender in RuleType, RuleValue should somehow allow the user to select a Gender from an Enum. Gender Enum has two elements i.e. Male and Female. Yes you are right that there is some inconsisitancy in the Data Types for RuleValue but I was thinking to store Enum positions in the form of string in RuleValue and later on whenever I need it I can programaticaly convert the string into number. I was thinking if I cant have a combo box in such a situation then I will create a custom lookup form for Gender Enum and use that. It will be a great help if you could give me some good solution. Thanks once again.
