I am hoping someone can tell me whether what I want to do (described below) is possible.  If it is then I'll figure out on my own how to do it.  I just don't want to spend a lot of time trying to do the impossible.  :)

 

I have a database that I'd like non-members to be able to search, add entries, and update entries.  Let's call this a product database that has fields for product name and product category.  Two products with the same name can be put into two categories, but not the same category.

 

I'd like for users to be able to search for products without limitation.  I want them to be able to add products and assign them to a category, and they should be able to modify their own entries.  But I don't want them to be able to overwrite someone else's entry.

 

Is it possible to include a field in the create form where the user would create a password and then would have to enter that password in the update form for his entry to be updated?   Is it possible to get the server to check on that field to make sure what the user entered is what is already in the db, before making any updates?  Also, is it possible to prevent the user from modifying the search string and getting other people's passwords?

 

I'm just looking for a way to allow various people to update a database without me having to create accounts for them.  This is not for a business. It's just a fun project for a gaming community and I'll make no money from it.

 

-----

 

Second, I read somewhere that it is possible to append two values together, such as a name and category.  Can that new value be stored in a new field while keeping the original name and cateogry fields unchanged?  In my case this presumably would let me use the name-category field as the key.

 

Thanks very much for any adivce anyone can offer.