Hi!

I have setup a nice database for horses with pedigree. Due to the big growth of the database I would like to make change and make relational one. I have found mod for this. So currently I have 45 fields in my flatfile database. Since there is a pedigree tree I could make relationship to the names in that tree of every horse, wright?

My fields are these:

'Name' => [ 1, 'alpha', 20, 255, 1, '', ''],

'Gender' => [ 2, 'alpha', 40, 255, 1, '', ''],

'Date_of_birth' => [ 3, 'date', 20, 255, 1, '', '^\w\w\s\w\w\s\w{4}$'],

'Date_of_decease' => [ 4, 'date', 20, 255, 0, '', '^\w\w\s\w\w\s\w{4}$'],

'Colour' => [ 5, 'alpha', 60, 255, 0, '', ''],

'Euro_ID' => [ 6, 'alpha', 20, 255, 0, '', '^\w\w\s\w{4}\s\w{4}$'],

'Owner' => [ 7, 'alpha', '40x5', 1000, 0, '', ''],

'Breeder' => [ 8, 'alpha', '40x5', 1000, 1, '', ''],

'Remarks' => [ 9, 'alpha', '40x5', 1000, 0, '', ''],

'Mother' => [10, 'alpha', 20, 255, 1, '', ''],

'Father' => [11, 'alpha', 20, 255, 0, '', ''],

'MMother' => [12, 'alpha', 20, 255, 0, '', ''],

'MFather' => [13, 'alpha', 20, 255, 0, '', ''],

'FMother' => [14, 'alpha', 20, 255, 0, '', ''],

'FFather' => [15, 'alpha', 20, 255, 0, '', ''],

'MMMother' => [16, 'alpha', 20, 255, 0, '', ''],

'MMFather' => [17, 'alpha', 20, 255, 0, '', ''],

'MFMother' => [18, 'alpha', 20, 255, 0, '', ''],

'MFFather' => [19, 'alpha', 20, 255, 0, '', ''],

'FMMother' => [20, 'alpha', 20, 255, 0, '', ''],

'FMFather' => [21, 'alpha', 20, 255, 0, '', ''],

'FFMother' => [22, 'alpha', 20, 255, 0, '', ''],

'FFFather' => [23, 'alpha', 20, 255, 0, '', ''],

'MMMMother' => [24, 'alpha', 20, 255, 0, '', ''],

'MMMFather' => [25, 'alpha', 20, 255, 0, '', ''],

'MMFMother' => [26, 'alpha', 20, 255, 0, '', ''],

'MMFFather' => [27, 'alpha', 20, 255, 0, '', ''],

'MFMMother' => [28, 'alpha', 20, 255, 0, '', ''],

'MFMFather' => [29, 'alpha', 20, 255, 0, '', ''],

'MFFMother' => [30, 'alpha', 20, 255, 0, '', ''],

'MFFFather' => [31, 'alpha', 20, 255, 0, '', ''],

'FMMMother' => [32, 'alpha', 20, 255, 0, '', ''],

'FMMFather' => [33, 'alpha', 20, 255, 0, '', ''],

'FMFMother' => [34, 'alpha', 20, 255, 0, '', ''],

'FMFFather' => [35, 'alpha', 20, 255, 0, '', ''],

'FFMMother' => [36, 'alpha', 20, 255, 0, '', ''],

'FFMFather' => [37, 'alpha', 20, 255, 0, '', ''],

'FFFMother' => [38, 'alpha', 20, 255, 0, '', ''],

'FFFFather' => [39, 'alpha', 20, 255, 0, '', ''],

'UserID' => [40, 'alpha', 20, 255, 0, '', ''],

'Certificate' => [41, 'alpha', 20, 255, 0, '', ''],

'Markings' => [42, 'alpha', 70, 255, 0, '', ''],

'Branding' => [43, 'alpha', 70, 255, 0, '', ''],

'SIRE' => [44, 'alpha', 12, 12, 0, '', '^\w\w\s\w{3}\s\w{3}\s\w\$']

Can somebody suggest me how to divede database to more databases (how many) ?

Do I need to create dropdown boxes for entry or not?

Sasa

I have setup a nice database for horses with pedigree. Due to the big growth of the database I would like to make change and make relational one. I have found mod for this. So currently I have 45 fields in my flatfile database. Since there is a pedigree tree I could make relationship to the names in that tree of every horse, wright?

My fields are these:

Code:

'ID' => [ 0, 'numer', 5, 8, 1, '', ''], 'Name' => [ 1, 'alpha', 20, 255, 1, '', ''],

'Gender' => [ 2, 'alpha', 40, 255, 1, '', ''],

'Date_of_birth' => [ 3, 'date', 20, 255, 1, '', '^\w\w\s\w\w\s\w{4}$'],

'Date_of_decease' => [ 4, 'date', 20, 255, 0, '', '^\w\w\s\w\w\s\w{4}$'],

'Colour' => [ 5, 'alpha', 60, 255, 0, '', ''],

'Euro_ID' => [ 6, 'alpha', 20, 255, 0, '', '^\w\w\s\w{4}\s\w{4}$'],

'Owner' => [ 7, 'alpha', '40x5', 1000, 0, '', ''],

'Breeder' => [ 8, 'alpha', '40x5', 1000, 1, '', ''],

'Remarks' => [ 9, 'alpha', '40x5', 1000, 0, '', ''],

'Mother' => [10, 'alpha', 20, 255, 1, '', ''],

'Father' => [11, 'alpha', 20, 255, 0, '', ''],

'MMother' => [12, 'alpha', 20, 255, 0, '', ''],

'MFather' => [13, 'alpha', 20, 255, 0, '', ''],

'FMother' => [14, 'alpha', 20, 255, 0, '', ''],

'FFather' => [15, 'alpha', 20, 255, 0, '', ''],

'MMMother' => [16, 'alpha', 20, 255, 0, '', ''],

'MMFather' => [17, 'alpha', 20, 255, 0, '', ''],

'MFMother' => [18, 'alpha', 20, 255, 0, '', ''],

'MFFather' => [19, 'alpha', 20, 255, 0, '', ''],

'FMMother' => [20, 'alpha', 20, 255, 0, '', ''],

'FMFather' => [21, 'alpha', 20, 255, 0, '', ''],

'FFMother' => [22, 'alpha', 20, 255, 0, '', ''],

'FFFather' => [23, 'alpha', 20, 255, 0, '', ''],

'MMMMother' => [24, 'alpha', 20, 255, 0, '', ''],

'MMMFather' => [25, 'alpha', 20, 255, 0, '', ''],

'MMFMother' => [26, 'alpha', 20, 255, 0, '', ''],

'MMFFather' => [27, 'alpha', 20, 255, 0, '', ''],

'MFMMother' => [28, 'alpha', 20, 255, 0, '', ''],

'MFMFather' => [29, 'alpha', 20, 255, 0, '', ''],

'MFFMother' => [30, 'alpha', 20, 255, 0, '', ''],

'MFFFather' => [31, 'alpha', 20, 255, 0, '', ''],

'FMMMother' => [32, 'alpha', 20, 255, 0, '', ''],

'FMMFather' => [33, 'alpha', 20, 255, 0, '', ''],

'FMFMother' => [34, 'alpha', 20, 255, 0, '', ''],

'FMFFather' => [35, 'alpha', 20, 255, 0, '', ''],

'FFMMother' => [36, 'alpha', 20, 255, 0, '', ''],

'FFMFather' => [37, 'alpha', 20, 255, 0, '', ''],

'FFFMother' => [38, 'alpha', 20, 255, 0, '', ''],

'FFFFather' => [39, 'alpha', 20, 255, 0, '', ''],

'UserID' => [40, 'alpha', 20, 255, 0, '', ''],

'Certificate' => [41, 'alpha', 20, 255, 0, '', ''],

'Markings' => [42, 'alpha', 70, 255, 0, '', ''],

'Branding' => [43, 'alpha', 70, 255, 0, '', ''],

'SIRE' => [44, 'alpha', 12, 12, 0, '', '^\w\w\s\w{3}\s\w{3}\s\w\$']

Can somebody suggest me how to divede database to more databases (how many) ?

Do I need to create dropdown boxes for entry or not?

Sasa