Two fields are linked to this lookup table: Album.Format and Want List.Format.
Format (Text 50)
The format description, for example LP, CD or 2CD. Use the Sort by field to specify the value that is used when sorting on this item.
Format ID (Numeric)
This is an unique ID number that is assigned to each entry in the table.
Format Group (Text 50 - lookup)
Specify the format group the format should be linked to.
Format groups are useful when creating reports and for statistical summaries. A vinyl album and a CD album should be specified as two different formats (for example LP and CD), but can be linked to the same format group (for example Album).
Format Image (Binary)
Select the image that is shown in the Tracks window when an album is linked to this format.
Marked (Yes/No)
This field indicates whether the record is marked or not.
Notes (Memo)
This field is for your own notes.
Sort by (Text 52)
This is the value that is used when sorting on this item. When you tab out of the Format field (or save the item), CATraxx will automatically fill in the Sort by field if it is empty.