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