Just a suggestion but I think unless you were going to have a large number of entries you may just want to have it all in one database.
If you were going to go with the relational I would suggest all the contact information in the main database, and then group all the children information into a second. No need to make a database for each child. For example:
Main:
Username - keyfield
PostDate
ModDate
Validated
Rolle
Last Name
Mothers name
Fathers name
Address (street)
Address (zip)
Address
Town/City
County
Telephone private
Telephone mobile
Telephone mobile
Email (Mother)
Email (Father)
Homepage URL
Presentation
Children:
Username - association between dbs
ChildrenID - keyfield
PostDate
ModDate
ValidatedC
Then repeat these fields for each child
Child_Name1
Birhplace1
Birthdate1
Adoptiondate1
ICBF1 (yes/no)
Orphanage1
Just an idea .. perhaps others will add their ideas.
Unoffical DBMan FAQ
http://creativecomputingweb.com/dbman/index.shtml/
If you were going to go with the relational I would suggest all the contact information in the main database, and then group all the children information into a second. No need to make a database for each child. For example:
Main:
Username - keyfield
PostDate
ModDate
Validated
Rolle
Last Name
Mothers name
Fathers name
Address (street)
Address (zip)
Address
Town/City
County
Telephone private
Telephone mobile
Telephone mobile
Email (Mother)
Email (Father)
Homepage URL
Presentation
Children:
Username - association between dbs
ChildrenID - keyfield
PostDate
ModDate
ValidatedC
Then repeat these fields for each child
Child_Name1
Birhplace1
Birthdate1
Adoptiondate1
ICBF1 (yes/no)
Orphanage1
Just an idea .. perhaps others will add their ideas.
Unoffical DBMan FAQ
http://creativecomputingweb.com/dbman/index.shtml/