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

Alison Balter

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

The tblPaymentMethods Table

This table lists the valid payment methods.

Table A.29. The tblPaymentMethods Table

Field Name

Type

Size (Bytes)

PaymentMethodID

Number (Long)

4

PaymentMethod

Text

50

CreditCard

Yes/No

1

Table A.30. The Field Properties of the tblPaymentMethods Table

Property

Value

PaymentMethodID

Number (Long)

AllowZeroLength

False

Attributes

Fixed size, auto-increment

Caption

Payment Method ID

CollatingOrder

General

OrdinalPosition

0

Required

False

SourceField

PaymentMethodID

SourceTable

tblPaymentMethods

PaymentMethod

Text

AllowZeroLength

False

Attributes

Variable length

Caption

Payment Method

CollatingOrder

General

OrdinalPosition

1

Required

False

SourceField

PaymentMethod

SourceTable

tblPaymentMethods

CreditCard

Yes/No

AllowZeroLength

False

Attributes

Fixed size

Caption

Credit Card?

CollatingOrder

General

Format

Yes/No

OrdinalPosition

2

Required

False

SourceField

CreditCard

SourceTable

tblPaymentMethods