Contents table: Standard fields

Previous pageReturn to chapter overviewNext page

The Contents table contains information about all sections (chapters, short stories, individual essays, etc., contained within books).

Author (Text 50 - lookup)

The name of the author(s). In the first column, type the name of the person. In the second column, specify the role you want to link the person to (Co-Author, Editor, etc.).

Author Pseudonym (Text)

Use this field to search for all works written by a specific author, no matter which pseudonym is used. For this to work you need to edit the "real name" in the Person lookup table, and enter the various pseudonyms in the Pseudonym field. You find more information here.

Author Relation (Text - lookup)

This field includes all related authors.

Book ID (Numeric)

The book's ID number. You cannot edit this field.

Chapters (Text)

You can use this field to register the chapters of the book. The list has three columns: Title, Page From and Page To.

Contents ID (Numeric)

This is an unique ID number that is assigned to each record in the table. You cannot edit this field.

Copyright Date (Date)

The copyright date. If you don't know the day and month, just specify the year.

Country (Text 50 - lookup)

The country of origin.

Credits (Text 50 - lookup)

Use this field for any additional credits. In the first column, type the name of the person. In the second column, specify the role you want to link the person to (Cover Design, Illustrator, etc.).

File Links (Text)

Here you can add links to files.

Full Title 1 (Text)

This field combines Title, Series and Release No into one field: Series (Release No): Title.

Full Title 2 (Text)

This field combines Title, Series and Release No into one field: Title (Series Release No).

Index (Numeric)

This field contains the section's index number, and is automatically maintained by BookCAT.

Item (Numeric)

This field contains the item the section is located in, and is automatically maintained by BookCAT.

Keywords (Text 150 - lookup)

This field is for listing keywords that describe the book.

Language (Text 50 - lookup)

The language.

Last Modified (Date)

The date/time the record was last modified. This field is automatically updated by BookCAT when you edit data.

Main Author (Text - lookup)

This field includes authors that are not assigned to any author role.

Marked (Yes/No)

This field indicates whether the section is marked or not.

Notes (Memo)

This memo field is for your own notes.

Original Copyright (Date)

The original copyright date. If you don't know the day and month, just specify the year.

Original Country (Text 50 - lookup)

If the work is translated, use this field to specify the original country of origin.

Original Language (Text 50 - lookup)

If the work is translated, use this field to specify the original language.

Original Publisher (Text 50 - lookup)

If the work is translated, use this field to specify the original publisher.

Original Release No (Numeric)

If the work is translated, use this field to specify the release number in the series.

Original Series (Text 50 - lookup)

If the work is translated, use this field to specify the name of the original series.

Original Subtitle (Text 255)

If the work is translated, use this field to specify the original subtitle.

Original Title (Text 150)

If the work is translated, use this field to specify the original title.

Page From (Text 15)

The first page.

Page From-To (Text)

This field includes both Page From and Page To as one field (for example, 10-25).

Page To (Text 15)

The last page.

Release No (Numeric)

If the work is part of a series, use this field to specify the release number.

Series (Text 50 - lookup)

If the work is part of a series, specify the name of the series in this field.

Title (Text 150)

The title.

Title Sort (Text 152)

This is the value that is used when sorting on the title. When you tab out of the Title field (or save the changes), BookCAT will automatically fill in the Title Sort field if it is empty. If the name begins with "A" or "The", BookCAT will automatically update the Title Sort field to reflect this.

Type (Text 50 - lookup)

The type of work, for example "Essay", "Short Story", or "Poem".




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