Borrower table

Previous pageReturn to chapter overviewNext page

Three fields are linked to this lookup table: Album.Borrower, Album.Reserved to and Loan History.Borrower.

Field Name

Type

Description

Bar Code No

Text 50

The bar code number.

Borrower ID

Numeric

This is an unique ID number that is assigned to each entry in the table.

Address

Memo

This is a memo field where you can specify the address.

Category

Text 50 (lookup)

Use this field to assign the borrower to a user defined category.

E-mail

Text 100

Here you can specify the e-mail address.

Fax

Text 25

Here you can specify fax number.

Marked

Boolean

This field indicates whether the record is marked or not.

Name

Text 50

In this field you specify the name of the borrower. Use the Sort by field to specify the value that is used when sorting on this item.

Notes

Memo

This field is for your own notes.

Phone

Text 25

Here you can specify phone number.

Sort by

Text 52

This is the value that is used when sorting on the name.

Web Link

Text

Here you can specify the home page URL.