John W. Vinson wrote in
news
I'd say that the FK field
should be required but that you should *not* use a zero default;
that's more a pain in the neck than any sort of benefit (since it
will always be wrong and need to be edited).

....and it won't work unless you create a record in the parent table
with 0 as the PK value.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/