it turns out that the regex table has Not Mull in the sql attribute. I
believe it should still be ok
I don't know anyway to let the OR designer to know that the parent table
(view is guaranteed to not have null)
one more hurdle is that I can't arbitrary specify the key attribute in view
as primary key as in dataset designer.
Consequently with no key, the association is useless as no code is generated