Hi guys, I am trying to get the attached section access to run smoothly... I have 2 fields and I am trying to limit the data where a country can be in either or both fields,
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION, PROFIT
ADMIN, ADMIN, ADMIN,
USER, USER5, U5, EUROPE, *
USER, USER5, U5, *, EUROPE
];
Section Application;
SALES:
LOAD * INLINE [
REGION, PROFIT
AFRICA, AFRICA
AMERICA, EUROPE
ASIA, OCEANIA
EUROPE, AMERICA
OCEANIA, EUROPE
];
I would expect user5 D in the above statement to see:-
OCEANIA, EUROPE
AMERICA, EUROPE
EUROPE, AMERICA
Any help is appreciated (basically I want Europe in 1 of 2 fields and it can be in one, both or neither)
If I'm not mistaken, here are a few things to consider:
1. To facilitate Data Reduction in Sectino Access, each one of the Section Access Fields (such as REGION and PROFIT) need to be associated with another Section Application field - foer example Region and Profit (proper casing versus upper case).
2. In order to facilitate * for "all", each link needs to be created separately, in individual link tables, and not together in a single table.
If I'm not mistaken, here are a few things to consider:
1. To facilitate Data Reduction in Sectino Access, each one of the Section Access Fields (such as REGION and PROFIT) need to be associated with another Section Application field - foer example Region and Profit (proper casing versus upper case).
2. In order to facilitate * for "all", each link needs to be created separately, in individual link tables, and not together in a single table.
