• Anna D Edson
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 1
    Replies
I am working on a custom app that has a Table with Cost Centers (3 digit codes assigned to G/L Accounts) and another table with G/L Accounts..

I need to be able to grant users access to only certain Cost Centers throughout the entire app, for example:

Users: Mike, Mary
Cost Centers 100, 200, 300, 400
G/L Accts: 100-600000, 200-600000, 200-601000, 300-600000, 400-600000

User Mike should be able to see only those G/L Accounts with Cost Centers 100 & 200
User Mary should be able to see only those G/L Accounts with Cost Centers 300 & 400

Mike can see G/L Accts: 100-600000, 200-600000, 200-601000
Mary can see G/L Accts: 300-600000, 400-600000

This should work in any Form or Report. What is the best way to implement this?

This may require custom programming and I am OK with that if anyone can suggest how to do it.

 
I am working on a custom app that has a Table with Cost Centers (3 digit codes assigned to G/L Accounts) and another table with G/L Accounts..

I need to be able to grant users access to only certain Cost Centers throughout the entire app, for example:

Users: Mike, Mary
Cost Centers 100, 200, 300, 400
G/L Accts: 100-600000, 200-600000, 200-601000, 300-600000, 400-600000

User Mike should be able to see only those G/L Accounts with Cost Centers 100 & 200
User Mary should be able to see only those G/L Accounts with Cost Centers 300 & 400

Mike can see G/L Accts: 100-600000, 200-600000, 200-601000
Mary can see G/L Accts: 300-600000, 400-600000

This should work in any Form or Report. What is the best way to implement this?
I am working on a custom app that has a Table with Cost Centers (3 digit codes assigned to G/L Accounts) and another table with G/L Accounts..

I need to be able to grant users access to only certain Cost Centers throughout the entire app, for example:

Users: Mike, Mary
Cost Centers 100, 200, 300, 400
G/L Accts: 100-600000, 200-600000, 200-601000, 300-600000, 400-600000

User Mike should be able to see only those G/L Accounts with Cost Centers 100 & 200
User Mary should be able to see only those G/L Accounts with Cost Centers 300 & 400

Mike can see G/L Accts: 100-600000, 200-600000, 200-601000
Mary can see G/L Accts: 300-600000, 400-600000

This should work in any Form or Report. What is the best way to implement this?
 
I am working on a custom app that has a Table with Cost Centers (3 digit codes assigned to G/L Accounts) and another table with G/L Accounts..

I need to be able to grant users access to only certain Cost Centers throughout the entire app, for example:

Users: Mike, Mary
Cost Centers 100, 200, 300, 400
G/L Accts: 100-600000, 200-600000, 200-601000, 300-600000, 400-600000

User Mike should be able to see only those G/L Accounts with Cost Centers 100 & 200
User Mary should be able to see only those G/L Accounts with Cost Centers 300 & 400

Mike can see G/L Accts: 100-600000, 200-600000, 200-601000
Mary can see G/L Accts: 300-600000, 400-600000

This should work in any Form or Report. What is the best way to implement this?