A form including content from two tables
The way you have the database setup seems fine.  I am not sure this is actually a DB admin question as much as it is a front end question.  

MySQL or MariaDB would be a fantastic DB to use this on.  You can also use MySQL Workbench, which is free, to manage the DB if you want.  I think for something this simple, I would just use the command line MySQL client.

If this is truly a front end question about how to make a form, I would recommend using the PDO functionality in PHP.

Once you decide this for sure, just ask about the proper queries to write and how to use PDO, if you need to.  (That might be more appropriate for Stack Overflow, though)