Use the File Attachments tab to extract files that are referenced within or associated with a row of extracted data and include it in an Archive or Extract File. You can attach multiple files to each row in a table.

The extracted file is "attached" to an extracted database row by three pseudocolumns within the Archive or Extract File. The pseudocolumns are:
Use the File Attachment List to provide details for
each attached file. Each row in the list represents a file that is
attached to the extracted data. The
column indicates the selected
row.
The file name for the attachment that is selected in the File Attachment List. The name is generated by concatenating values from listed columns with any literals you enter.
You must enter each literal or column name in order on a separate row. Enclose literals in quotation marks and select column names from a drop-down list of CHAR, VARCHAR, NCHAR, and NVARCHAR columns in the table.
The name resulting from concatenating the values and literals is combined with the search paths to locate the appropriate file. For example, if you provide the column name USERID and the literal ".txt" as file name parts, Optim™ searches for and attaches the first file that is named 123.txt that is located in a designated search path when processing a database row with the value "123" in the USERID column.
One or more paths, which are separated by a semicolon. These paths are the default search paths for any attachments to any table referenced in the Access Definition. They are searched if Use Default Search Paths is selected in the File Attachment List for any file. Paths are searched in the order listed. After the file is found, any remaining paths are not searched. Use the browse button to select paths.
Use the following commands from the File Attachments List and the File Name Parts list.
A File Attachment icon
in the Table Specifications
column on the Access Definition Editor table
list indicates that File Attachment specifications are defined for
the table.