how to insert record into table and otherTable

hi All,

I insert a record into the Cartable, In my table contain Carid, Model,brandname. while i insert the record into the table at the time only carID will be inserted into the TestTable, where TestTable also having carid field and data type is same as Car table.

Kindly help me and how will i do?

Thanks in advance

Regards

stan