Value list by calculation

[sved]

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]

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".