Who's On?

	Membership:
	Latest: sakkatan
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5216

	People Online:
	Visitors: 26
	Members: 0
	Total: 26

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Security Can getdbfields access a field in a related table?

1 Replies

0 Subscribed to this topic

18 Subscribed to this forum

Sort:

Author

Messages

Anne

New Member

Posts: 4

New Poster

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: 3364

New Poster

Engaged Reader

Avid Reader

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.