13. SETTING UP A BAYALA DATABASE
​
On deciding to create a database, the first thing to do it to create the fields.
Fig. 13.1 A few of the fields in the ALLSYD database
In the illustration above some of the field in use in the ALLSYD database can be seen.
After the fields have been created, changes by addition, amendment and deletion can occur at any time.
Layouts can then be made, to display the fields in any desired arrangement. In the case of the Bayala databases, colours were added to help distinguish between the many columns used.
Many databases are simple, but not so the Bayala databases, which were able to become increasingly useful through relationships.
Fig.13.2 Relationships structure of the ALLSYD database
​
The above illustration reveals the relationships that enable the ALLSYD database to work. The green rectangles to the upper left control the eight Elaboration bars, the yellow rectangles below control theJSM links in the LINKS layout, and the brown rectangle below the control the NoH links in the same layout. Each of these is connected to the ALLSYD database, which is the tall grey rectangle in the centre on the illustration.
On the right are the various other relationships — for searching, geographical purposes, for the transcription keys. Others control the pictures, the source details, and the special characters.
MAKING A SEARCHER PANEL WORK
Fig. 13.3 Layout for the ALLSYD SEARCHER NoH
Once a layout has been created, it is necessary link all the constituent blank fields to the appropriate field name in the relational link concerned (here, ALLSYD SEARCHER NoH).
If it is done correctly, something like the following will result:
Fig. 13.3 ALLSYD SEARCHER NoH in use: in the bottom right, the word ‘wara’ was entered
Fig. 13.5 ALLSYD SEARCHER NoH in use: next, the word ‘bada’ was entered
SUMMARY LINES
Summary lines have been described earlier, created by the key combination ‘option-shift-Z’. This was used to create:
"Pattadiou" bada-dya-wu = "I eat or have eat [eaten]" eat did I: Anon (c) [c:19:10] [BB]
for the first record in the illustration immediately above. But how does this happen?
It is the result of coding in a program ‘QuicKeys’. The programming is the following:
tell application "FileMaker Pro"
set Australian_field to cellValue of cell named "Australian" of current record
set suffixDFX1_field to cellValue of cell named "suffix DFX 1" of current record
set suffixDFX2_field to cellValue of cell named "suffix DFX 2" of current record
set suffixDFX3_field to cellValue of cell named "suffix DFX 3" of current record
set suffixDFX4_field to cellValue of cell named "suffix DFX 4" of current record
set suffixDFX5_field to cellValue of cell named "suffix DFX 5" of current record
set suffixDFX6_field to cellValue of cell named "suffix DFX 6" of current record
set suffixTENSE_field to cellValue of cell named "suffix TENSE" of current record
set qualifier_field to cellValue of cell named "qualifier" of current record
set suffixPRONOUNNOM_field to cellValue of cell named "suffix PRONOUN NOM" of current record
set suffixPRONOUNACC_field to cellValue of cell named "suffix PRONOUN ACC" of current record
set suffixPRONOUNNOMpost_field to cellValue of cell named "suffix PRONOUN NOM post" of current record
set suffix1_field to cellValue of cell named "suffix 1" of current record
set suffix2_field to cellValue of cell named "suffix 2" of current record
set suffix3_field to cellValue of cell named "suffix 3" of current record
set nohyphens_field to cellValue of cell named "no hyphens" of current record
set English_field to cellValue of cell named "English" of current record
set EnglishJSmain_field to cellValue of cell named "English JS main" of current record
set EnglishJSDFXtense_field to cellValue of cell named "English JS DFX tense" of current record
set EnglishJSadj_field to cellValue of cell named "English JS adj" of current record
set source_field to cellValue of cell named "source" of current record
set notebook_field to cellValue of cell named "notebook" of current record
set page_field to cellValue of cell named "page" of current record
set line_field to cellValue of cell named "line" of current record
set langshort_field to cellValue of cell named "langshort" of current record
if suffixDFX1_field is not equal to "" then
set suffixDFX1_field to "-" & suffixDFX1_field
end if
if suffixDFX2_field is not equal to "" then
set suffixDFX2_field to "-" & suffixDFX2_field
end if
if suffixDFX3_field is not equal to "" then
set suffixDFX3_field to "-" & suffixDFX3_field
end if
if suffixDFX4_field is not equal to "" then
set suffixDFX4_field to "-" & suffixDFX4_field
end if
if suffixDFX5_field is not equal to "" then
set suffixDFX5_field to "-" & suffixDFX5_field
end if
if suffixDFX6_field is not equal to "" then
set suffixDFX6_field to "-" & suffixDFX6_field
end if
if suffixTENSE_field is not equal to "" then
set suffixTENSE_field to "-" & suffixTENSE_field
end if
if qualifier_field is not equal to "" then
set qualifier_field to "-" & qualifier_field
end if
if suffixPRONOUNNOM_field is not equal to "" then
set suffixPRONOUNNOM_field to "-" & suffixPRONOUNNOM_field
end if
if suffixPRONOUNACC_field is not equal to "" then
set suffixPRONOUNACC_field to "-" & suffixPRONOUNACC_field
end if
if suffixPRONOUNNOMpost_field is not equal to "" then
set suffixPRONOUNNOMpost_field to "-" & suffixPRONOUNNOMpost_field
end if
if suffix1_field is not equal to "" then
set suffix1_field to "-" & suffix1_field
end if
if suffix2_field is not equal to "" then
set suffix2_field to "-" & suffix2_field
end if
if suffix3_field is not equal to "" then
set suffix3_field to "-" & suffix3_field
end if
set cell named "word for word JS" of current record to quote & Australian_field & quote & tab & nohyphens_field & suffixDFX1_field & suffixDFX2_field & suffixDFX3_field & suffixDFX4_field & suffixDFX5_field & suffixDFX6_field & suffixTENSE_field & qualifier_field & suffixPRONOUNNOM_field & suffixPRONOUNACC_field & suffixPRONOUNNOMpost_field & suffix1_field & suffix2_field & suffix3_field & " =" & tab & quote & English_field & quote & tab & EnglishJSmain_field & space & EnglishJSDFXtense_field & space & EnglishJSadj_field & ":" & tab & source_field & " [" & notebook_field & ":" & page_field & ":" & line_field & "] [" & langshort_field & "]"
end tell