Dear all. I have a database with 4 hierarchical levels, and I would like to show in the first hierarchy table not only the records that are linked to it through a lookout field, but also records that are linked to the child table through another lookout field. Example.

Table 1: Experiment

Table 2: Treatment

Table 3: Subject

Each Experiment consists of multiple treatments, and each treatment of multiple subjects. Table 1 and 2 are related through a lookout field, and Table 2 and 3 are related through another field.

I want to display in Experiment, a list of Subjects that are included within that experiment.

Could anyone help, please?