Open the UD User Defined Lookups form in Vista and copy the existing JCCT lookup. Modify the new lookup as shown below.
- JCCT with (nolock)
- JCCO.JCCo = ?
- INNER JOIN HQCO ON JCCT.PhaseGroup = HQCO.PhaseGroup
INNER JOIN JCCO ON HQCO.HQCo = JCCO.JCCo
Configure the lookup in Viewpoint by following the steps below.
- Open PR Timecard Entry and click the Field properties on CostType(CT)
- Click the Lookups tab in the field properties window and add the custom lookup created above
- Enter in the parameters as shown in the screen shot below (19)
- Change the load Sequence to 0 and ensure that it is the only 0