• Search Forums
    Advanced Search Topics Posts
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
 16 Subscribed to this forum
Sort:
Author
Messages
Anne
New Member Send Private Message
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
Send Private Message
Posts: 3351
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