Creating complex subfiles without an indexed link

• Suprlink can link files on any field
• QUIZ requires an index to link
• How do you create a QUIZ subfile with the required fields?
• Two steps:
  1. Build a one-record subfile of each data file2. Link subfiles on record number to create new subfile >Access *SALSUB link to record(0) of *CUSTSUB
  >report summary CUST-ACCOUNT NAME-FIRST ...
• Subfiles must have correct item definitions; data not important

Previous slide

Next slide

Back to the first slide

Back to the main menu

View Graphic Version

Notes:

Because Suprtool can link files in non-index fields, it is sometimes impossible for QUIZ to perform the same logical linkage to create the subfile. In these cases, the following steps can build a subfile with the correct field sequence and characteristics from any two files that contain the required fields:

1. Create a one-record subfile of each file2. Link the subfiles on record number3. Create a single subfile with the required fields from the two smaller subfiles

It is not important that the two files used to be logically related, only that they contain the fields required to create a mini-dictionary which correctly describes Suprlink's output records.