Add employee drill-select to custom form

Sort:
You are not authorized to post a reply.
Author
Messages
Woozy
Veteran Member
Posts: 709
Veteran Member
    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
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Woozy
    Veteran Member
    Posts: 709
    Veteran Member
      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
      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      You are not authorized to post a reply.