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. |
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. |