How to display selected category in a form for each different user
Posted on 2004-08-18
I have a form and on this form, there is a dialog list field called meetingtype which gets the value from another view. The values are Manager,Sales, Supervisor,Employee,Other.
I have created roles for this database - Manager, Sales, Supervisor, Employee, Other.
How do I code my meetingtype field or my form such that when user A access this db, user A roles are Employee and Other so when user A create this form, when he click on the meetingtype field, it will show Employee and Other and no other values.
When another user B Supervisor access this db, user B roles are Supervisor,Employee and Other.So when user B creates this form, when he click on the meetingtype field, it will show Supervisor,Employee and Other.