title: MySQL Auto Insert Record Into TableB when TableA record is created
body: <p>I have two tables. msUser and msUserChar. I have created a relationship between msUser and msUserChar where the PK in msUser is a FK in msUserChar</p>
  
  <p>What I need, is when a record is inserted into msUser, a record is also created in msUserChar where it's FK is the PK from msUser. </p>
  
  <p>I have tried using constraints, update cascade and various other relationship methods. I am aware, I can use the Last_Insert_Id method, or use transactional mysql and only commit when both records have been created. I am wondering however, if there is a way to do this in a relationship manner. </p>
  
  <p>Essentially, ever user must have a character. So when the user table is inserted with a record, a related record is created in the user character table.</p>
  
  <p>as requested, here are the tables described: </p>
  
  <pre><code>+-----------+------------------+------+-----+---------+----------------+
  | Field     | Type             | Null | Key | Default | Extra          |
  +-----------+------------------+------+-----+---------+----------------+
  | _msId     | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  | msUser    | varchar(25)      | NO   |     | NULL    |                |
  | msPass    | varchar(30)      | NO   |     | NULL    |                |
  | msSecret  | varchar(30)      | NO   |     | NULL    |                |
  | msEmail   | varchar(45)      | NO   |     | NULL    |                |
  | msAccType | int(2)           | NO   |     | NULL    |                |
  | msLastLog | datetime         | YES  |     | NULL    |                |
  +-----------+------------------+------+-----+---------+----------------+
  
  +---------------+------------------+------+-----+---------+----------------+
  | Field         | Type             | Null | Key | Default | Extra          |
  +---------------+------------------+------+-----+---------+----------------+
  | _msCharUserID | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
  | _msId         | int(10) unsigned | YES  | MUL | NULL    |                |
  | _msCharID     | int(10) unsigned | YES  | MUL | NULL    |                |
  | msChar_1      | int(10)          | YES  |     | NULL    |                |
  | msChar_2      | int(10)          | YES  |     | NULL    |                |
  | msChar_3      | int(10)          | YES  |     | NULL    |                |
  +---------------+------------------+------+-----+---------+----------------+
  </code></pre>