I have a fmp 5 database which i have made web ready through Lasso WDE/Webstar & Go Live plug in.

There are 10 clients who create new records for requests on certain criteria

What I would like to do is have each client have a passowrd/login-ID on the index page (not a default "pop up" browser user entry) to access/edit/create and delete only their records not the other clients.

How is this possible.

Many thanks for any help

To do this on database level set the all user access to search, update, delete add a password and username field to the database and a field which adds the two together (concatenates)when the user creates their record. To stop people accessing your add format files I'd recommend using WebSTAR realm access control (stronger security)

Set the field level properties on this field to exact match in lasso security. In the login format file add the username and password using javascript. add onclick="document.formname.UsernameandPasswordHiddenObjectName.value=document.formname.UsernameTextObjectName.value+document.formname.UsernameTextObjectName.value; return true"> to your search submit button or Nothing submit button if you're using inlines. this should then do an exact search on the single field but using the username and password values (cheating but it works!) don't forget to set either password or username to unique values so you get an add error if any of your users try to have the same login.

If I'm not making sense post your email and I'll send you the pages. It's not the only way to do it but it's easy and if you use inlines no one can reallly tell how you do it!