Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Limiting access to records


dee2dum

This topic is 8198 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi-

I'm trying to limit the access of certain records for the users of the database I'm creating. Basically, my database is a log open to "x" number of people. When they open the database I'd like only the records they enter to appear. In the help function it says that you can do this by having a password that only allow each user to view the records they created. Is it possible to create a seperate password for each person instead of just one?

Thanks in advace for the help.

Link to comment
Share on other sites

If you are using filemaker pro 5.5 in the passwords you can limit the records that users can browse, edit and delete.

Basically, if when your users login you capture their login through a database and store in a global field you can do

If( _gLoginUser=CreationUser,1,"")

This requires the CreationUser to auto enter the creator name (or pick up the name from the _gLoginUser

If you add this to all three options, they can only browse, edit and delete the records where the creation user equals the current login username.

HTH

Link to comment
Share on other sites

This topic is 8198 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.