This feature allows you to define up to ten separate lookup items (each to their own database) and each lookup has ten copy items.
Within the screen design select ‘Parameters’ and then the option ‘Extra File / Record Lookup and Updating’ followed by the option ‘Custom Points’.
Set the option number ‘9904’ as the custom point number and leave the suffix blank. You will then be prompted to change the ‘Extra 10 Lookup’ definition – respond ‘Yes’ to this.
Database No - here you select the lookup database. Note that a pre-existing lookup relationship must exist (as defined in the Data File Profiles).
Item – here you specify the item on the main file that is used for the lookup.
Mandatory – set this according to whether the operator must enter a lookup code.
After responding to the mandatory prompt a pop-up parameter screen will allow setting of up to ten copy items – specify the ‘from’ and ‘to’ data items. Copy Items are only actioned when the value in the lookup field is first set or when it is changed – if set to forcethe copy items are actioned each time the lookup code is confirmed.
Article ID: 1258
Created On: Fri, Jun 29, 2012 at 12:08 PM
Last Updated On: Tue, Jun 20, 2023 at 5:15 PM
Online URL: https://kb.datafile.co.uk/article/extra-10-lookup-options-9904-1258.html