I'd like to split a table into 2 different tables. I want to link them using the primary key. For example: primary key in table1 will link to primary key in table 2. I believe I would setup some kind of foreign key for this. I'm wondering how I can have the system automatically create the record in table2 when a record is added in table1. (it would be a 1 to 1 relationship)