> > >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
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com