Security Can getdbfields access a field in a related table?

Sort:
You are not authorized to post a reply.
Author
Messages
Anne
New Member
Posts: 4
New Member
    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
    Senior Member
    Posts: 3348
    Senior Member
      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
      You are not authorized to post a reply.