index
The table property is accessed when creating a new table or via the context
menu for a specific table.

This is where the basic properties of a table are set.
-
Its name, which should be unique
-
Its datasource, can either be a local database or
an come from an external datasource.
Clicking on the Data Source button will bring up the datasource
screen, where datasources
can be defined or edited.
-
Clicking on the DB Table button provides a selection box of table names
looked up from the external datasource.
-
Fields can be added 1 by 1 (with the New Field button) or fetched from
the remote DataBase with the dB Fields button).
-
The field lists : Clicking on the info column (
)
goes to the field's property's (as does the Options->Advanced
Properties menu). To included fields in the new table select
the tick or cross icon (
).
Display Name is the name of the field as it would be used in
ihookDB.
DB Field Name is the name of the field in the external DataSource (if
any).
The name could be edited by clicking in the corresponding cell.
The fields appear in the order they would be displayed, this order could be
changed by clicking on a row and use the up/down button (
),
alternatively the fields could be sort by name by clicking on the column's
title.
The Advanced Properties screen.

-
Use
Select to included this field in the new table.
-
Col Width is the column width used in the records
list
-
Display Name is the name of the field as it used in ihookDB
-
Field Type
sets the field type, such as String or Date etc.
-
Visible
Select to display this field to the end user or not
-
Allow Null whether or not this field supports null values, if not you should
set a default value
-
Primary Key
this field is required to interact with a database, it's not needed with local
databases. (FileMaker users don't have to worry there is an internal &
invisible RECORDID pseudo field used instead. Note: There shouldn't be a
FileMaker Field name called "RECORDID".)
-
Identity
An other kind of primary key for SqlServer database. There could be only one.
They are readonly auto-incremented integer.
-
Auto Increment
if the field is an auto-incrementing Integer
-
Read Only
whether or not this field is editable by the user and would be submitted back
to the database
-
Local Only
this field is used locally only and is not used to interact with the external
database.
-
Default Value
the default value for a new record
-
Value List select a list of value to use with this field. The ValueList
button allows editing in the value list screen