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 ?