Go to user record on login
I've tried a few different approaches to this but would like some input if possible.
I have three departments:
Each has their own login (they keep staff records and details in the system). Whilst I use the same layout for creating the department and for their own staff record, I want Sales to use their own login and see only the staff layout showing their record and also when they look at the 'staff' layout they see only the records where say Department=Sales.
Any ideas? I don't think I need to create individual tables for each department. The HR department need to see al staff so they'll have an admin login which lets them see all departments.