Inserting data into table1 should insert data into table2's FK ???

[Paul Fine]

Duhhhh....

If I have two tables with the first table containing a field which is FK of
table 2, when I insert a value into this field, should it not automagically
insert a value into that PK in the second table?


Thanks!