Jump to content
Sign in to follow this  
Greg Hains

Client Specific Records

Recommended Posts

This is probably a simple one, but I am having trouble implementing it.

I have a database that will have a number of clients accessing it on the web. These clients will login, and only access records belonging to them - in my case, the login name with be used is a client field and thats all they can access.

If at any time they "Show All Records" they will see the records of other clients as well. Whats the best way to get around this.

I was thinking of having a client-x.fp7 for each client so they only see what is in their file prefer to work in a single file only - instead of multiple.

How can I prevent them seeing all records other than their own please?

Greg

Share this post


Link to post
Share on other sites

If at any time they "Show All Records" they will see the records of other clients as well. Whats the best way to get around this.

Firstly, you need to use Filemakers accounts and privileges to explicitly restrict access to the records (don't just rely on scripts as these can potentially be circumnavigated). For example, you could set a privilege set that matches the 'user company' field (this could be a global set at login based on their account details) with the 'data company' field and only allows those records to be viewed. Then, any records that do not match those criteria will display "<>" in all the fields.

Next, you will want to script any functions like 'Show All Records' or 'Perform Find' to restrict any found records to those that match the above criteria. This way you can prevent the user from having to navigate through multiple "<>" records to find the ones they want to see.

Does this give you a starting point?

Share this post


Link to post
Share on other sites

Thanks tv_kid

I will look closely at the explicit record access.

Cheers,

Greg

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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