--- In firebird-support@yahoogroups.com, "kogerbnz" <kogerbnz@...> wrote:

>
> > I'll ask again: what are you trying to accomplish?
>
> I have a one-to-one relationship. In the "mastertable" I want to store
> a type about which other table to look up the additional fields. I
> want to store this type as one of the values from a text set.
> Hope you understand what I mean, but I think the workaround was
> already posted.
>

And that is a near perfect example of the dangers of an enum datatype.
Normalise your design properly, and this requirement 'goes away'.

http://en.wikipedia.org/wiki/Data_domain

Adam