I agree. The other approach I thought is to enter a "dummy" record with blank entry in the primary table and "hide" it from the user. But maybe I will learn to live (code) with NULLs instead of empty entries.
Speaking about triggers. Do I understand correctly that specifying foreign key constraint with cascade option is pretty much the same as used to be done with triggers to update foreign keys?
>The only way around is to write your own FK validation using triggers. I don't think it worth the hassle.
>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham