I have about 200 users and I need to create a mechanism that when a user logs into the membership area, that they are only able to see their profile and cannot see others. Any advice?

Thanks

This process is known as Record Level Access. Create a field that auto enters the user's Account Name. Then in the Privilege Set definition for the Privilege Set that controls these Accounts, set the browse privileges to be where the Account Name and the value entered in the field are the same. This will limit a user to seeing his or her own records. There can be some performance hit as a result of this technique.

Steven

Hi again Steven

I got so far as to the field auto entering user name but this just seems to prevent access to the whole record rather than the field itself. Idea is that one field can be used by everyone, but user can only see his own data within that field. Maybe I missed something? I'd be happy to mail you the file and a nice bottle of wine via paypal if you can help me out; I'm slowly going insane with this :)

Hi

Did you get this to work at all - I am trying to do something similar with a field on the screen which all can access but can only see what they have entered there?

I got so far as to the field auto entering user name but this just seems to prevent access to the whole record rather than the field itself. Idea is that one field can be used by everyone, but user can only see his own data within that field. Maybe I missed something? I'd be happy to mail you the file and a nice bottle of wine via paypal if you can help me out; I'm slowly going insane with this

Who might you be? You're not the Original Poster who was seeking Record Level Access. There isn't field level access based on a specific user, although I have often been tempted to try to invent such a thing. Thre are probably a couple of workaround ways to do this; however, they are likely real kludges.

Steven

Hi

Did you get this to work at all - I am trying to do something similar with a field on the screen which all can access but can only see what they have entered there?

Ah ha. The Original Poster returns. Did you try Record Level Access?

Steven

Hi again.

I got as far as getting the user name to auto enter, but got completely lost after that!

My client wants the solution by Tuesday and I am starting to sweat :

Could I send you my data file - happy to pay for your time ?

Could I send you my data file - happy to pay for your time ?

So sorry. I cannot take on anything else just at the moment.

Steven

OK, understood & thanks for your help. I have got it working fine in filemaker with some tricky permission options, but when I access through IWP the user, whilst he sees his personal data, he can't edit it. I know there are some limitations in IWP but my scripts are all pretty simple so, once again, I am stumped!

For web users try adding an Open Record script step.

Steven

Thanks for that. Could you expand a little?

I am part way to solving this - by opening the remote file in Filemaker, logging in as each user and creating a private, user specific note the user is then able to login through the web, see and edit that note or indeed click "next" to go to the next found record and add a note or edit one. However, if the user then either performs a find by clicking a button or changing to list view then back again the ability to add and edit seems to disappear.

Weirder and weirder.......