Insert to custom fields into another table in database

Hi all,

Working on a website where we will be adding dogs. ( yes, bark, bark ). We use the post as a web form. Using custom fields for the Breed, Name, Size and so on. This data goes into the wp_post_meta table.

What I want to do, is insert this same data into another table called doggy. I want to have one clean table for listing the dogs ( to be rescued and adopted by the way)

So, on a Post, when I click submit, I want to put that data in the doggy table too. I cannot find where the code is to do my insert.

Can anyone help?

Thanks in advance.

Karen