Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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
];
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