> > > >If TBL_PERSON and TBL_PARTY share the same PK - why don't you
> > > just have the
> > > >fields in TBL_PARTY to the TBL_PERSON table.
> > >
> > > :))) Because I have a TBL_COMPANY as well.
> > >
> >
> > If it's the same thing then I would argue the same ting again..
> > You don't win anything in terms of storage, or speed or efficiency by
> > separating fields across tables when they all share the same PK.
> > Use FK logic for where it applies - i.e. many records for a single
> > master/parent
>
> Or for completely optional parts. :-)
>
> With regards,
>
> Martijn Tonies

True - if these additional fields are only very sparingly used.. perhaps
but I'm not sure that even then you would win anything... the data is
already very compressed, if no fields are filled, then very little space is
occupied.
Alan