Hey All,
I'm redesigning my front end, just wondered if anyone can think of a way to filter a drop down list depending upon which user is logged on?
For example if the user called 'Manager' is logged on then the options in the list would be say: Manager Diary, Reception Diary, Customer Feedback, Financial, User Manager
If user called 'Reception' was logged on then the options in the list would be: Reception Diary, Customer Feedback, Financial
and if user 'Other' was logged on then the options in the list would be: Reception Diary, Customer Feedback
The idea is which ever option is chosen from the drop down box menu then the textbox for that field would be visible. At the moment I use a switchboard type access with tabs etc but I am looking to redesign and freshen it up a bit.
Thank you,
Malcolm
I'm redesigning my front end, just wondered if anyone can think of a way to filter a drop down list depending upon which user is logged on?
For example if the user called 'Manager' is logged on then the options in the list would be say: Manager Diary, Reception Diary, Customer Feedback, Financial, User Manager
If user called 'Reception' was logged on then the options in the list would be: Reception Diary, Customer Feedback, Financial
and if user 'Other' was logged on then the options in the list would be: Reception Diary, Customer Feedback
The idea is which ever option is chosen from the drop down box menu then the textbox for that field would be visible. At the moment I use a switchboard type access with tabs etc but I am looking to redesign and freshen it up a bit.
Thank you,
Malcolm