You aren't inserting the value of that select list into the database. You have to open your insert record server behavior and bind the associated column to the select list form field.
Menu and list work the same way. You have that set correct if it looks how you want it to.
It also looks like you have an old version of insert on the page with the MySQLi version. I think that can be removed. Delete lines 37-111 because I don't think you are using them anymore.