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

Alison Balter

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

The tblCorrespondenceTypes Table

This table stores the valid correspondence types. It relates to the tblCorrespondence table and is a lookup table for the CorrespondenceTypeID stored in the tblCorrespondence table.

Table A.13. The tblCorrespondenceTypes Table

Field Name

Type

Size (Bytes)

CorrespondenceTypeID

Long Integer

4

CorrespondenceType

Text

50

Table A.12a. The Field Properties for Each Field in the tblCorrespondenceTypes Table

Property

Value

CorrespondenceTypeID

Long Integer

AllowZeroLength

False

Attributes

Fixed size, auto-increment

Caption

Correspondence Type ID

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

OrdinalPosition

1

Required

False

SourceField

CorrespondenceTypeID

SourceTable

tblCorrespondenceTypes

CorrespondenceType

Text

AllowZeroLength

False

Attributes

Variable length

Caption

Correspondence Type

CollatingOrder

General

ColumnHidden

False

ColumnOrder

Default

ColumnWidth

Default

DataUpdatable

False

DisplayControl

Text Box

IMEMode

0

IMESentenceMode

3

OrdinalPosition

2

Required

False

SourceField

CorrespondenceType

SourceTable

tblCorrespondenceTypes

UnicodeCompression

True