I am trying to create a database for preschool families and running into what I think is a fairly simple issue to fix…but I can’t figure it out.
How do I organize the tables?
- We have CHILDREN and we have PARENTS.
- Some parents have multiple children.
- Some parents are divorced (e.g. different addresses)
We have an online form where we get child names, parent names, parent addresses, etc.
Right now I can make it so I can join the kid with one parent in the table but when I try to join them to a 2nd parent it creates a new column.
I want to be able to look up a child’s record and show BOTH their parents names. Do I need to create a table called FAMILIES to join the kids with 2 different parents? Do I need to create a PRIMARY PARENT and determine just one parent to be primary (I’d rather one if I don’t have to).