Oops... hit send too soon then!!
You can use the Live_Status to control access or denial of the Client in question.
Also, thinking about it and a bonus is that you easily control access to the same clients via different users or owners if you allow multi client/owner/user relationships.
i.e one client can be a client of many owners and an owner can be allocated to many users if required
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Dave Crozier Sent: 18 January 2017 17:26 To: ProFox Email List profox@leafe.com Subject: RE: Restrict access to multi clients
One other possibility if you don't want to use the "*" feature which involves exception programming is to include a record in the table for every User/Owner/Client entry and then add another boolean field called Live_Status which would allow access to the client or not. This makes any queries easy to generate as you would include where Live_Status = true (or TSQL equivalent) when extracting any query information.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Andrew Stirling Sent: 18 January 2017 16:05 To: profox@leafe.com Subject: Restrict access to multi clients
I'm trying to get an online system working that allows: Users to log in to an Owner organisation ie firm of accountants. Owner to display list of clients to work on.
So I have that working with User: Id owner_id
Owner Id
Clients Id owner_id
User has owner relationship and owner has client relationship.
Thus User can choose from a list of clients to work on.
HOWEVER what I want is to be able to restrict the clients that the User can see.
How do I go about that?
-- Kind regards
Andrew Stirling 01250 870397 07910467915 support@calcpay.co.uk http://www.calcpay.co.uk
--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]