I have narrowed my problem down to this. I think I have a mismatch in the value in my section access table and the value in the reduction field.
Here is my inline table:
LOAD * INLINE [
ACCESS, USERID ,SALESMANID
The reduction field (SALESMANID) is a text field and contains values like 209, 0209, n209.
If I put a value in my inline that contains a character like n209, then my section access works. But if I put in a numeric value like 0209 then I get access denied. I have verified that this value exists in the table.
What do I need to do to make sure that the value in my section access is identical to the value in the table? I tried using text() but that didn't change anything.