Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 287
	Members: 0
	Total: 287

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

Add employee drill-select to custom form

1 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Woozy

Veteran Member

Posts: 709

2/2/2011 5:13 PM

I haven't done much (or anything) with drill previously, so I'm having trouble.

I have a custom form over a custom table. This form has an EMPLOYEE field from the custom table, but doesn't have a COMPANY field (because the table doesn't have it).

How do I make the drill-select for my EMPLOYEE field correctly return the employee list(s) like the HR11 EMPLOYEE field?

Attached is the .scr for my custom form.

Thanks for your help!

Attachments

ZH55scr.txt

Woozy

Veteran Member

Posts: 709

2/2/2011 7:03 PM

Never mind! I got my answer from a buddy. I'm posting it here in case it helps someone else.

In the .scr, I had to add a field in the MAP section, just before the employee number, as "+0001]" for the static COMPANY value. Then I added an EMP-COMPANY row in the $TRANS section just above ZZE-EMPLOYEE. Once I did this, it worked like a charm, and the COMPANY still doesn't appear on the screen, which is nice.

Attached is the revised .scr in case your are interested.

Attachments

ZH55scr_fixed.txt