Field Name | Description | 1º Key | Foreign Key | Paradox Field | |
ArchiveNo | Long Integer | ||||
ArchiveType | Photo, field notes, image file | Alpha, 15 characters | |||
ArchiveNotes | Memo, 20 characters displayed |
Field Name | Description | 1º Key | Foreign Key | Paradox Field Type | |
LocPrefix | Locality | Alpha, 2 characters | |||
LocalityNo | Locality | Long Integer | |||
ArchiveNo | Archive | Long Integer | |||
ArchiveType | Archive | Alpha, 15 characters |
Field Name | Description | 1º Key | Foreign Key | Paradox Field Type | |
AccessionNo | Museum accession number | Accession | Long Integer | ||
ArchiveNo | Number assigned to archive | Archive | Long Integer | ||
ArchiveType | Type of archival material (e.g. Letters, photographs) | Archive | Alpha, 15 characters |
Field Name | Description | 1º Key | Foreign Key | Paradox Field | |
Section | Section of Institution (Vertebrates, Plants etc.) | Specimen | Alpha, 3 characters | ||
SpecimenNo | Specimen number | Specimen | Long Integer | ||
ArchiveNo | Archive | Long Integer | |||
ArchiveType | Archive | Alpha, 15 characters |
Field Name | Description | 1º Key | 2º Index | Foreign Key | Paradox Field | |
FieldNo | Alpha, 15 characters | |||||
ArchiveNo | Archive | Long Integer | ||||
LocPrefix | Locality | Alpha, 2 characters | ||||
LocalityNo | Locality | Long Integer |