Home » Categories » Solutions by Business Process » Profiler

Copy Items from Lookup Databases (9901)

Datafile Software

Copy Items from Lookup Databases (9901)

This feature provides an additional 48 copy items from a lookup database within ProFiler screens. Within the screen design press <F7-Option>, select ‘Parameters’ and then the option ‘Extra File / Record Lookup and Updating’ followed by the option ‘Custom Points’.

Set the option number ‘9901’ as the custom point number and leave the suffix blank. You will then be prompted to change the ‘Extra Look Up Copy Items’ definition – respond ‘Yes’ to this.

Extra Copies from Look-Up Database No (1-8) – here you select the database number, as listed in the Profiler applications ‘Location of Files’ for the lookup file. Note a pre-existing lookup relationship, as defined in the Data File Profiles, must exist between the file the screen is based upon and the selected database.

Copy From / To – here you can enter up to forty-eight copy items from the lookup to the main file (database screen is based upon). The usual rules regarding matching of field types apply.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
User Defined Report – Output to Excel
Viewed 893 times since Wed, Jun 13, 2012
T – Table Updating
Viewed 771 times since Fri, Jun 29, 2012
B – Blank out a Database
Viewed 800 times since Thu, Jun 28, 2012
Copy Items Back to Lookup File (9902)
Viewed 1461 times since Fri, Jun 29, 2012
P – Program
Viewed 783 times since Fri, Jun 29, 2012
G5 – Full Database Audit
Viewed 864 times since Thu, Jun 28, 2012
System Maintenance - EDI Order Processing
Viewed 1522 times since Thu, Jul 5, 2012
Reprint Pending Orders - EDI Order Processing
Viewed 1431 times since Thu, Jul 5, 2012
Perform Direct a Database Function
Viewed 1373 times since Fri, Jun 29, 2012
Maintain Constants
Viewed 1429 times since Fri, Jun 29, 2012