Subject RE: Re[2]: [firebird-support] Primary Key, Foreign Key
Author Alan McDonald
> >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.
>
> --
> Best regards,
> Alexander mailto:saho@...

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

Alan