Home » Categories » Solutions by Business Process » Profiler

Extra 10 Lookup Options (9904)

Datafile Software

Extra 10 Lookup Options (9904)

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Benefits of EDI
Viewed 2040 times since Thu, Jul 5, 2012
General Lookup File - EDI Order Processing
Viewed 2109 times since Thu, Jul 5, 2012
Screen Design – Allow Increased Screen Sizes
Viewed 163 times since Wed, Oct 23, 2024
Restructure a Database
Viewed 2108 times since Fri, Jun 29, 2012
Auto Create Live Files from Base Files
Viewed 548 times since Wed, Oct 23, 2024
User Defined Reports - Email Links
Viewed 1988 times since Wed, Jun 13, 2012
EDI Message Header File
Viewed 2118 times since Thu, Jul 5, 2012
A – Audit a Database
Viewed 999 times since Thu, Jun 28, 2012
User-Defined Reports - Report Last X Records
Viewed 1798 times since Mon, Jun 11, 2012
Disk File Suffix Codes
Viewed 2361 times since Fri, Jun 29, 2012