Attempting to create a database that stores info on families we serve at a non-profit. Can anyone tell me if the design I have so far is going to work? I'm trying to collect info of each child, guardian and general info about the family like primary language and gross income.
Thanks for replying. We have a paper form that we fill out about a family enrolling their child or children. On the form it has locations to enter multiple children, multiple guardians, primary address, mailing address, primary phone, message phone, primary language, number of family members and combined family gross income. I want to get them away from using the paper form. We would probably run anonymous demographic reports and want to be able to look up child and related guardian info quickly.
There are many ways to achieve the same results and you could have all of this data in one table. With the power of access, you can have hundreds of children and it would still work OK.
However, my opinion, as a fairly novice database designer would be:
One table for children. On this table I would store all the information on that child.
Another table for Guardian. This table would store the name, address, phone numbers etc of the guardian.
The Children table would have a one to many relationship with the Guardian table.
Then build a form based on each table.
Then drag the Guardian form onto the Children form and link them. Then for each record of a child you can flick through the guardians.
You can easily use the search functions to find a particular child and even if you have two children with the same name, you will easily be able to find the one you want by checking you have the correct address.
I am sure other people on this site will correct my view if there is a better way.