2. ASPRunnerPro General questions
  3. Questios
This topic is locked

Questios

 		10/28/2006 3:23:17 PM
ASPRunnerPro General questions
M
 mikehook author

I want to use two fields in advanced security settings like:

I have one mainID and within that there are SubID, so I want access for users main and sub to be able to edit, add and such.
I want to show the same in a view format to only see information for that mainID and then for that SubID
Mike McCormick
Sergey Kornilov admin 11/1/2006

Mike,
I recommend to split MainID and SubID into two tables with master-details relationships between them.
In this case you can implement advanced security for both tables using MainID as an OwnerID.
C
 		chris 11/2/2006

Mike,

I recommend to split MainID and SubID into two tables with master-details relationships between them.
In this case you can implement advanced security for both tables using MainID as an OwnerID.


I have something similar in request, the database I am using I would like to use for multiple users from multiple companies, I would like to have users only see data from their company and then only certain users be able to edit, etc.

I have part of this set up, I use groups to control who can do what, but not sure how to tackle the other issue of user only see his company data only, not necessarily the individuals data only.

I thought of using a field in each table to populate with a code or company name and use that as control for this, but was wondering if anyone else has any ideas.

Thanks,

Chris.