I followed these steps and appears to work, but wanted a quick double-check in case I forgot something.
1. App has to be setup so that the top-most Parent is a Table with just the Regions. This Parent has one to many relationship to numerous Child Tables.
2. Setup a Role for each of the two Regions and a role for the manager who accesses all.
3. Permissions for the regional roles - Create a Custom Rule for Each Table to restrict access to REGION = East or Region = West. I must create the custom rule at each table if I want all data to be separated by Region for this role.
Permissions for the Manager: No custom rule, can View, Can Modify all tables.
4. The View, Edits, Add, Delete, Reporting for the Regional roles will be separated for the user automatically base on the Regional role they are assigned
Thanks!
