Your primary Key could have a lot of fields on it ;). Think about this, You can't repeat your primary key in your table..

So, if in the Child_* table, you can have the same child more than once (easy example, usually a kid could be picked up by more than one person Child_Permitted), then you need your PK to be the kid and the adult.

And I still think you need more work on the child table and the career table. There is a lot of repetitive info on that tables (religion, medication, legalguardian, relationship to the child).

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========