I have a DB with a salesperson table with salespersonId as the key and I have a table customer that has a field of salespersonId in it. When a salesperson loggs in I want them only to be able to view the customers with their salespersonId. I also have a "manager" that I want to be able to see everything. I would assume I should just use roles for that... but need help...
I am not opposed to restructuring the DB or anything else. Any help will be much appreciated!!!
...
Go to the complete details ...