Subject Re: [ib-support] One-to-one relationship
Author Tumelis Giedrius IF 5/1
On Wed, 16 May 2001, Nico Callewaert wrote:

> Hi list,
> Can someone explain to me what is the advantage of a one-to-one
> relationship ? I don't see any advantage on it, because a single record in
> the first table is related to only one record in the second table, so why
> don't put it all in one table then ?

because in the first table may be some more primary keys, as candidate
keys. I dont know is there ability of store more than one candidate keys
in a table in the interbase , but if you use them, then is possible to
have one table with two candidate keys and two 1:1 relations to another
two tables thru one candidate key and thru another candidate key.