Currently I have about 6 different levels of users and each user can only set specific status for records. But each user level is different. Right now I have to create a view for each level and then in the visual editor I have defined the drop down menu on status and only put in the status they can use. All the pages for each level will have several events and editing of the code in the visual. So it be much easier if there was a way that I could just create a table of the different levels and what status that can show up. That way I only have to create one view instead of 6. But how does the page know what level the user is so it can pull out the correct status for that level. I hope this makes sense? Note the records don't show who is logged in.
Any ideas be great!
Kim
Idea:
Can I in the Lookup table for status field set the table to the status table? But what kind of where statement would I use for it to find user level or even username to match it status choices. The two fields I have in status would be level and status
I also should mention I am using 4.1 version