Understanding Record Definitions

Fields that are grouped together as a unit are record definitions. A record definition represents what the underlying SQL database tables look like and how they process data. Two tabs exist in record definitions.

Use the Record Fields tab to access the fields that compose the record definition.

This example illustrates the fields and controls on the Record Fields tab.

Use the Record Type tab to specify way that the record definition is to be used, for example a SQL table or view, or perhaps a temporary table.

This example illustrates the fields and controls on the Record Type tab. You can find definitions for the fields and controls later on this page.