IWP: Logging on to just one record?

Hello All:

FMP Advanced 9.01 Mac

-Published via IWP

-I have a database where each record is a city, and carries info such as hotel, contact, travel, meals, etc. for each city (record).

-I would like to have people enter info into a record that corresponds to their city. For instance, the hotel would access the record for their city, and be able to enter their phone number, or address, etc.

One solution is to break up the database and have a bunch of databases with just one record, then the hotel would go to the home page and click their 'city', and be prompted for Login/Pass. The problem with that is I would have to have hundreds of open databases on my desktop. I don't really like this solution.

My "grand plan!" is to have each record generate a random password, then email it to the hotel, and when the hotel enters that password on the webpage, it takes him to the related record. They would only be able to see and edit 'their' record...

I can't figure out how to USE the password in the login page. Maybe I could let everyone through the home page, but then the first page of the database is a login page that I build, where I could use the entered number to jump to the related record?

Any ideas would be greatly appreciated!

JP

--