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.
- Parent Form ID
- Child Form Ref (reference of child form ID)
- Child Form ID
- grandchild Form Ref (reference of grandchild form ID)
- grandchild Form ID
- Column A
- 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.