Limit user to only see specific records
I have three users; Bill, Bob and Ted. When they log in I only want Bill to see records where the department field = sales. Bob only to records from the accounts department etc. You get the idea.
I have a field on each of the personnel records the three people will view that state the person on the record works in sales, accounts or manufacturing.
What's the easiest way to do this? I've tried several routes but none are very efficient.