You can use multiple Reduction levels to handle your case:
'USER' as ACCESS,
upper("USERID") as USERID,
CUSTOMER as REDUCTION_C,
GROUP as REDUCTION_F,
ACCOUNT as REDUCTION_A,
'' as OMIT
And your Section Access table should look like:
In the example above the ABC1000 user has an access to ALL ABC Customers and also to the RRR5000-0-01 and FFF4000-0-01 Accounts....
And RRR5000 user has an access to all RRR Customers as well as to ABC1000-1 Group....
So you can do it for multiple levels...
P.S. When applicable, please mark this answer Correct or Helpful.
Yes, Section Access - enabled apps might be tricky to handle....
I am always keeping a copy with SA disabled, to make sure I can open it anytime.
Check the domain\username section in your SA code. Please remember you have to use UPPERCASE text there.
Make sure you convert your records in your data table, using Upper() function.
And make sure you've assign few users to ADMIN role.
These are basic steps, so it should work in most cases. Please let me know if the problem is still exist after you've applied all these steps.