Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources]

Alison Balter

نسخه متنی -صفحه : 544/ 500
نمايش فراداده

The tblContactTypes Table

This table stores the valid contact types. It relates to the tblClients table and is a lookup table for the ContactTypeID stored in the tblClients table.

Table A.17. The tblContactTypes Table

Field Name

Type

Size (Bytes)

ContactTypeID

Long Integer

4

ContactType

Text

50

Table A.18. The Field Properties for Each Field in the tblContactTypes Table

Property

Value

ContactTypeID

Long Integer

AllowZeroLength

False

Attributes

Fixed size, auto-increment

Caption

Contact Type ID

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

OrdinalPosition

1

Required

False

SourceField

ContactTypeID

SourceTable

tblContactType

ContactType

Text

AllowZeroLength

False

Attributes

Variable length

Caption

Contact Type

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

DisplayControl

Text Box

IMEMode

0

IMESentenceMode

3

OrdinalPosition

2

Required

False

SourceField

ContactType

SourceTable

tblContactType

UnicodeCompression

True