Multi-Level Security Question

Hi,
First, make sure you can link an owner ID field between the store's sales records table and the specific store's user login table to give

you the function of the owner only seeing their own information. Then set that link between the two into the advanced security settings

for those tables.
Next, if you don't have another field in your store sales tables that identifies what district each store is in, you will need to create that

field and load it with the district ID data. Once that is done, create a custom view (Add View in the Datasource tables page)

of the store's tables. With the custom views, you will link the district manager's user login to the district ID field and set the advanced

security settings to only see their district's sales information.
Then, for the VP Sales, create another custom view of those same tables and set the advanced security settings to see and edit other users data.

This will enable the VP to see all the sales records.
Then under permissions, create distinct groups for each (Store, District, VP) and set permissions only within that custom group that you created

for them. You will tie the group permissions with a field in your user login table that defines each user to that group. (i.e. Store, District, VP).
I have used this design many times with success. Let me know if you need me to give you further examples of my data tables structure.
Good Luck
Gene....

AIMS