Multiple values in Section Access

[Anonymous]

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID,  LINK

ADMIN, admin, *

USER, user1, UK

USER, user2, US

USER, user1, SPAIN

];

SECTION APPLICATION;

DATA:

LOAD * INLINE [

COUNTRY, SALES,LINK

USA1, 150,US

United Kingdom, 250,UK

Spain1, 350,SPAIN

India1, 350,INDIA

];

As per above data the user1 can view the data for LINK-SPAIN and UK. But to achive this I need to add 2 rows for user1.

Is is possible to have one row for user1 and specfiy SPAIN and UK in the same row.

[swuehl]

Create a link table that link LINK values for SPAIN and UK to a new field value, e.g. SPAINUK.

Then use this new field as reduction field.

This is a common approach if you want to link to all values in an application field without stating these in the section access table explicitely.

Basics for complex authorization