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

Barcode (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 (Yes/No)

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.

Do you have question? E-mail us at support@fnprg.com.