I have done some further testing of the updates and I can tell now why the updates are not occurring. It is because of the way that you have information in the tables. In order for an update to work the record that you are updating must already exist in the table. It looks like your tables are lookup tables that just maintain the information about the relationship of the amenities to the type and location.
As an example here is one of the update queries that the server behavior was trying:
UPDATE `amenitiesother` SET `amenitiesID` = 60, `resortID` = 310 WHERE `otheramenitiesID`=60
This update will not occur because there is no otheramenitiesID id that is set to 60. I think that you should be using the Manage Relational Table server behavior for this. When you set it up you should make sure to reference the resortID value from the URL then bind the amenityID is set to the value from the form. The id of this table should be handled for you so you do not need to worry about that value.