having trouble setting up referential integrity

[Dylan Snyder]

I have a table I am splitting into three tables in a one to one fashion(because I was told to do it) The Index of the original table is set to:
Item Key (autonumber)
and UPC Number

I have created the two new tables from the original table, have added Item Key as the Primary key on the original table and the two child tables. I have set referential integrity for the relationships, but adding a new record will not add a new record to the child tables. Can anyone suggest something that I am doing incorrectly?

 

[KeithG]

Why do you need the 1 to 1 relationship? Usually these are only gused if there are additional fields that some recods my need to have.

 

[Dylan Snyder]

They will go into differnet databases. It's not really necesary, but the boss says I have to do it