Field Name

Type

Description

Address

Memo

The snail mail address.

Alternate Names

Memo

Use this memo field for any alternate names.

Artist

Boolean

Check this field is this is an artist. Only items marked as "artist" are shown in the Artist drop-down list in the Album and Track Edit windows. The name of artists are also shown in bold text in the Artist/Person Lookup View.

The program will automatically check this field for all artists added via the Artist fields (Album and Track Edit windows).

Artist/Person ID

Numeric

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

Biography

Memo

In this memo field you can add the biography.

Birth Name

Text 100

The birth name.

Birth/Formed Location

Text 150

The birth (person), or formed (group), location.

Born/Formed

Date

The year (or date) the person was born, or the group was formed.

Country

Text 50 (lookup)

The country of origin.

Custom 01

Text 150

This is a standard text field.

Custom 02

Text 150

This is a standard text field.

Custom 03

Text 150 (lookup)

This is a text field linked to a lookup table.

Custom 04

Text 150 (lookup)

This is a text field linked to a lookup table.

Custom 05

Memo

This is a memo field.

Custom 06

Date

This is date field.

Custom 07

Boolean

This is a checkbox field.

Custom 08

Boolean

This is a checkbox field.

Custom 09

Boolean

This is a checkbox field.

Custom 10

Boolean

This is a checkbox field.

Death Location

Text 150

The death location.

Died/Disbanded

Date

The year, or date, the person died, or the group was disbanded.

E-mail

Text 100

The e-mail address.

Fax

Text 25

The fax number.

File Links

Text

In this field you can add links to local files on your PC.

Genre

Text 50 (lookup)

The genre. If you use this field you can for example easily look up "blues artists" or "classical composers".

You can automatically set the album, track and playlist genre to the same as the artist genre. For more information, see To update genres.

Image

Binary

This field contains the image if it is stored in the database.

Image - Comments

Memo

Comments about the image.

Image - Compressed

Boolean

Specifies whether the image is compressed or not (only applies to BMP images).

Image - External

Boolean

Specifies whether the image is stored externally (that is, only a link to the image is stored in the database) or not.

Image - File name

Text 255

If this is an external image, this field holds the file name.

Image - Thumbnail

Binary

This field contains a thumbnail of the image. The thumbnail is automatically created when you modify the image.

Image - Type

Numeric

The type of image: 0 - bmp, 1 - gif, 2 - jpeg, 3 - png, or 99 - other.

Marked

Boolean

This field indicates whether the record is marked or not.

Lineup

Text

This fields contains the lineup information (members of the group).

You can use the lineup information when you specify persons (songwriters, producers and musicians) that participate on an album. If you do this you save a lot of time when you add credits information.

For more information, see To specify lineup information.

Name

Text 100

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

Personal Rating

Text 50 (lookup)

You can rate artists. This allows you to, for example, create a dynamic playlist with tracks by your favorite (5 star) artists.

In the data entry window, you can press the + or - button to select rating without having to open the list.

Phone

Text 25

The phone number.

Relation

Text

Use this field to link to other related artists/persons. For example, you can link The Police to Sting, and Joy Division to New Order (and vice versa).

When you search or group by either the Album.Artist Relation or the Track.Artist Relation field, CATraxx will automatically include all albums/tracks by the related artists.

Sort by

Text 102

This is the value that is used when sorting on this item. When you tab out of the Name field (or save the item), CATraxx will automatically fill in the Sort by field if it is empty.

Type

Text 50

The type of artist/person, for example Group, Solo Artist, Duo, Musician or Band Member.

You can set up a background color for each type (to edit a type, right-click the type in the Type field and choose Edit from the popup menu). The background color is used to color code artists/persons in the Artist/Person Lookup View and in the Artist drop-down list in the Album and Track Edit windows.

Web Links

Text

In this field you can add links to web sites.