From: David W. Fenton on
John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in
news:o05fs5h1f7k74gvhiflasee0dj4sko1skp(a)4ax.com:

> 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/