I work for a non profit child care centre in canada. We have developed a database for our children's registration, we used access 2003. We're opening a second site and thing it's a good time to reevaluate our database.
I'm looking for suggestions on programs to use and some feedback on how to organize the fields.
currently we use each child and the main group, and other fields such as the guardians are included.
our problem is that we have multiple children from the same family, so when a phone number or address changes, we have to go through all the children and update the parent info seperately.
Does anyone have suggestions of organizing the data so that parent info can be linked across children? I hope that makes sense.
I am not the most technical but am learning, thanks!