Use the information below to modify the UD field in Vista.

Open the UD User Defined Lookups form in Vista and create a lookup with the clauses shown below:

• From
  • SMCO with (nolock)
• Join
  • INNER JOIN HQCO on SMCO.SMCo = HQCO.HQCo

    

    

    Configure the lookup in Vista by following the steps below:

    1. Open PR Timecard Entry and click the Field properties on SMCo.
    2. Click the Lookups tab in the field properties window and add the custom lookup created above.
    3. Change the load Sequence to 0 and ensure that it is the only 0.