Open the UD User Defined Lookups form in Vista and create a lookup with the clauses shown below
- SMCO with (nolock)
- INNER JOIN HQCO on SMCO.SMCo = HQCO.HQCo
Configure the lookup in Viewpoint by following the steps below.
- Open PR Timecard Entry and click the Field properties on SMCo
- Click the Lookups tab in the field properties window and add the custom lookup created above
- Change the load Sequence to 0 and ensure that it is the only 0