Populating a table from an existing table using mySQL

I am getting an id value for a given store from a tbl_locations and I'm inserting it into RelatedID in tbl_MaxHoursByMarket. When I find one of these stores in the tbl_locations, I also want to insert 'Location' into the RelatedType field of tbl_MaxHoursByMarket. How can I do this? Below is my code...


I didn't immediately see a way to delete this posting, so I am just going to mark it solved.