Posted by DA Morgan on 06/30/05 09:05

rjl444@hotmail.com wrote:
> I created 2 tables with one to one relationship. if I add a record in
> table A, how does table B record get created? Does SQL do this
> automatically because it is one to one relationship? or do I need to
> create a trigger? if i need a trigger, how do I get the ID of new
> record to create the same ID in table B?
> thanks for any help.
> Joe Klein

From the standpoint of pure design: What justification is there for
two tables with a 1:1 relationship?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Back to original message]