Can I have an html form with 1 submit button that can add values to two different mysql tables?
Yes. The adding of data to the MySQL tables happens in the script that your form calls. So you can do whatever you want with the data there.
yes you can have