Use this dialog box to specify the properties of
Existing database tables or fields can be included in a project one by one (rather than having them extracted automatically). For example, use this command when adding a table to a database structure.
Primary Key Icon
Specify that the field is part of the
Field Name
Display the name of the field you want to add. You can change the field name by typing a new one.
Data Type
Specify the type of data the field contains. If you do not know what kind of data the field contains, select Unknown.
The following describes the English Query data types and their equivalent Microsoft® SQL Server™ data types:
Integer—int, smallint, tinyint
Float—real, decimal, numeric, money, small money
Date—datetime, smalldatetime
String—char, varchar
Bit—bit
Text—text
Binary—binary, varbinary, image
Other—timestamp (anything not listed above)
GUID—a globally unique identifier
Caption
Optional. Specify the label for this field, if one exists.
For example, the LastName field may have a caption of Last Name, which is used on forms.
Basic Tab
Use this tab to define the fields in your project.
Advanced Tab
Use this tab to further define the fields in your project.
Advanced Tab (Table/New Table Dialog Box)