I didn’t if I should start a new post or use the old one, but I do not see George on line.
He has been helping me with a db for disabled children. He normalized my tables and added many more. I am making this database for Part C of Early Intervention for Children and I have to make it on my own time. When I said I would set a db up for them (Marge) I had no idea that there was so much information, needing so many fields that needed to be related (connected) to each other.
George broke my tables into so many little ones that I don’t know how to put it together.
For the demographics of each child there are 4 tables; tbl_Child; tbl_ChildAddress; tbl_ChildDiabilityDiagnosis; tbl_ChildRecord. My first thought was to make subforms for the tbl_Child, tbl_ChildAddress, tbl_ChildDiabilityDiagnosis and put them into a main form of the tbl_ChildRecord and this would be where the first information of a new child would be entered.
An obvious problem is that it makes the form huge. I could put each table (subform) onto tab pages and have the tbl_ChildRecord as a subform, would that work?
My confusion is all the fields George put in the tbl_Child such as:
HouseParentID; HouseParentTypeID; ChildIntakeByID; ChildSexID, why doesn’t he just have HouseParent (name); HouseParentType(Guardian); ChildSexID (female). My original db had these fields at combo lists.
Can you explain the reason?
Then he has table that join fields. Example: trelChildServiceProvider the fields in this table are:
ChildProviderID PK auto
All I need for the Provider is his name, the agency he works for (a combo box because I have a table for Service Provider info), phone and address which would be pulled from the combo box in an event. The ExitDate is for the child. And I don’t know what the last two are for, something he thought was needed.
What is the prefix “trel”. I think part of my fear is that there is so many tables and I have never really made a db that was normalized and I don’t know where to start. Do I make forms or queries first? And How do I make queries with so many tables?
Please Help me!! I fill like it’s the first day of an Access class for beginners.
I have attached the database. If you need more information about the Part C program I will be happy to include it.
P.S. I have all day today to work on this. And Thank you to whom ever replies.