How do I use enumerations with an inherited property

[PAPutzback]

I have a field called membertype and I only want the user to be able to select from the enumerations.

Public Enum MemberTypes As Integer
Subscriber = 1
Patient = 2
SubAndPatient = 3
End Enum

Public Overrides Property MemType() As Integer
Get
Return MyBase.MemType
End Get
Set(ByVal value As Integer)
MyBase.MemType = value
End Set
End Property

So when the user goes to set the value they only see the 3 options. Is this possible?

Thanks,
Phil

[dnparsons]

Most databases do not have an ENUM column data type (MySQL being the notable exception.) The solution is to create a MemberType table and a foreign key constraint.