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.
Article ID: 1252
Created On: Fri, Jun 29, 2012 at 11:28 AM
Last Updated On: Tue, Jun 20, 2023 at 5:16 PM
Online URL: https://kb.datafile.co.uk/article/copy-items-from-lookup-databases-9901-1252.html