Adding Detail Line Data
Header/detail forms contain header information and detail lines. The header includes key and required fields. The worksheet you create to upload/add data must include a column for each key and required field in the header, plus columns for each field in the detail line.
To add detail data to the form, use the Map Columns tab on the Upload Wizard to map each worksheet column to the correct form field. When you add records, you only need to map a column containing detail field data to the first detail line on the form.
Example
You want to add nine new records to Employee Status Codes, HR03.1. The form contains a header field and detail lines.
Create a worksheet that contains a column for the key header field Company plus a column for each type of detail field.
As long as each row contains a valid Company number, you can put data for each detail line in a separate row.
Because you are adding new data and not changing existing records, you can map worksheet columns to the first detail line on the form. If you have included the necessary key and required field information in the worksheet, each line of the worksheet is added as a new detail record.