In this example, Suprlink reads each customer record in the input file and links it to the first matching sales record in the link file. If linkage is optional and there is no match, Suprtool writes the input customer record to the output file and initializes the link record fields to blanks or zeros.

QUIZ reads each record in the Access file and links it to every matching record in the link file. If linkage is optional and there is no match, the link record fields are initialized to dictionary defaults.

With Suprlink, you should create many-to-one links instead of one-to-many. By changing the input file, the Suprlink output file would contain the same records as the QUIZ extract, but the sequence of the fields would be different.

Since QUIZ repeats the link field in its output file, the length of the output record is the sum of the lengths of the two data records.