Prev
Next
Forums Infor / Lawson Platforms S3 Security

Security Can getdbfields access a field in a related table?

 1 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Anne
New Member
Posts: 4
New Member
11/1/2010 6:45 PM
    I'm using this code to try to get the job class and it's not working.  Do I have the right syntax for the related field?  Do I have to do 2 nested queries to achieve this?

    if(trim(getDBField('EMPLOYEE','JOB-CODE.JOB-CLASS',form.REV_COMPANY,form.REV_EMPLOYEE))=='DIR')
       'NO_ACCESS,'
    else
       'ALL_ACCESS,'
    John Henley
    Posts: 3353
    11/1/2010 7:23 PM
      Not that I know of; you have to do two getDBField calls, one to get the employee's job code, another to get the job class for that job code.

      Thanks for using the LawsonGuru.com forums!
      John