Data from grand child to parent form

[Rahul_Bhalla]

hi,
i have 3 tables parent, child and grandchild.

in child table i select the reference to grandchild form and enter values in a grandchild.
in parent i select the reference to the child form. what i need is to get few columns from the grand child form to the parent form after i select the child reference in parent form.

Table Parent:

1. Parent Form ID
2. Child Form Ref (reference of child form ID)

Table Child:

1. Child Form ID
2. grandchild Form Ref (reference of grandchild form ID)

grandchild Child:

1. grandchild Form ID
2. Column A
3. Column B

so in the above table when i select the child form reference in table parent, i want the Column and Column B to be auto populated / auto shown in the parent form as a table view.

thanks