Excel Data File Format

The following table explains the rules for the Microsoft Excel workbook to use for the linked combo display type:

	Rule for	Description
1.	Worksheet names	The worksheet names should follow the format: Number-Name Where: - Number is the serial number based on the order of the worksheet and it should start from zero. This means that the number for the first worksheet should be 0, the second should be 1, the third should be 2, and so on. - Name is the name of the worksheet that identifies the data it contains. It can be anything you want.
2.	Identity column	Each worksheet should have an identity (ID) column that contains a unique value for every record entered in the sheet.
3.	Name column	Each worksheet should have a Name column. This column contains the values to be displayed in the linked combo. For example, the Name column in the 0-Company worksheet contains the company name for every record in the sheet.
4.	Foreign Key column	Each worksheet that contains data related to that on the previous sheet, should have a foreign key identity column (FK). This column contains the ID of the record (from the immediately previous sheet) that the current record relates to.