I have a database for students DStu, a database for incidents report DInc, one for communcation with parents Dcom and a database for social emotional report DSoc
The DStu is sync with the three other database so we can add incident or social emotional concerns/interventions connected to one students or multiple students.
I would like to create one more database which will combine:
The student
- Any incidents related to him/her
- Any social emotional concern/intervention related to him/her
- Any communication to parents related to him.
How can I do this ?