I am planning something similar as you where hotels can update
information about themselvs, and my idea is to use a relationship where
the password and a username is the relationship primary key, so the
hotel only see this one record. You then must hava a second database
where you creats a relationship based on the username and password, and
through this relationship you will see only this one record with the
matching username and password.
I think it maybe can be one solution to crate a script that contains:
-from the hotel recrod, you start the script.
-it creats a password and username and sets this in the username and
password field on the current record.
-it creats a useraccunt with the username and password
-it creats a url to the database where you have the username and
password in the url so you get right to the database and the login
screen with the username and password already entered (I think this is
possible..)
-it creats a email to the hotelboss and sends some info about pleas
update and click the url.
the boss now goes to the webpage with the url and is logged in to the database.
-it sets the username and passwordfield with data, so the relationship
with the one record information is displayed
-it goes to one field, so it is in edit mode
-the hotelboss enters the information and hits Save.
-the scripts continues with commit record, and you can see the edited
info and do something more. When you are finisched you have to confirm
the entered information
-when confirming the useraccount is deleted and then you wil be logged out.

What do you think?

Nicolay