Section Access

[#1]

Is it possible to assign two values to the same user. I have a field with values [ value1, value2, value3.... value 10]

I want user1 to access value2,value3,value5 and user2 to have access to value2, value6 and user3 to have access to value1 etc. IS this possible??

[Carlos_Reyes]

Yes, you have to create a record for each combination of user and value in the Section Access table. Something like the next:

[Section Access]:

LOAD * INLINE [

ACCESS, NTNAME, FIELD1

USER, USER1, VALUE2

USER, USER1, VALUE3

USER, USER1, VALUE5

USER, USER2, VALUE2

USER, USER2, VALUE6

USER, USER3, VALUE1

];

[#3]

Hey Anitha,

If the table in your Data Model already has the relationship you mentioned built in then its possible. For example if the table looks like this:

User	Field
User1	value2
User1	value3
User1	value5
User2	value2
User2	value6
User3	value1

So it all depends on how that values are related in your Data Model tables.

Hope it helps

Thanks

AJ