Create an SM Company Lookup

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 select the Field properties on SMCo.
      2. Select 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.