Newbies sved Posted August 10, 2011 Newbies Posted August 10, 2011 Hi, I have a text field (OutcomeVariable) in a table, that is displayed on a layout. I want the user to enter a value in that field based on a value list. I have two different value lists that can be used for this field. If User 1 enters the layout, I want the layout to display ValueList 1. If User 2 enters the layout, I want the layout to display ValueList 2. Three items that are in ValueList 1 are not in ValueList 2. Could you comment on the following: 1. Is it possible to set it up such that User 1 sees ValueList 1 and User 2 sees ValueList 2? If yes, how? 2. Should I just have two different tables, one for User 1 and the other for User 2? Thank you.
comment Posted August 10, 2011 Posted August 10, 2011 You need one value list that will change dynamically according to the current user. Create a new table for the values, and for each value select the users that are allowed to use it - this could be a checkbox field. Define a relationship between your current table and the Values table, based on matching an unstored calculation field returning the current user (in your current table) to the checkbox field.in the Values table. Set the value list to use only related values from the Values table. Note: you probably should use the current privilege set instead of "user".
Recommended Posts
This topic is 4873 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now